By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,602 Members | 1,533 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,602 IT Pros & Developers. It's quick & easy.

load file to clob using loadfromfile(oracle8.1.7),but the length of file and clob is not equal

P: n/a
fils:=bfilename(directory => receiveDir,filename => fileName);
dbms_lob.open(fils,dbms_lob.file_readonly);
dbms_lob.createtemporary(xDoc,true);
---------------- the result is 353
dbms_output.put_line(dbms_lob.getlength(fils));
dbms_lob.loadfromfile(xDoc,fils,dbms_lob.getlength (fils));
-------------- the result is 176
dbms_output.put_line(dbms_lob.getlength(xdoc));
dbms_lob.close(file_loc => fils);
commit;

I just want to test if I can load a text file into database with
content unchanegd,but the answer from this fact is not.How I can load
a txt file (xml file) into database without changing the content.
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.