dbms_lob.loadfromfile() reads trash

My table looks like:

(docnum char(10),inhalt clob);

I am inserting the content of a XML file with the following code:

srcloc BFILE;
myclob clob;
...
srcloc :=BFILENAME('TMP','test.xml');

select inhalt into myclob from ojs_de where docnum='test' for update; dbms_lob.open(srcloc,dbms_lob.lob_readonly); dbms_lob.loadfromfile(myclob,srcloc,dbms_lob.getlength(srcloc)); commit;
dbms_lob.close(srcloc);

The CLOB column is initialized with empty_clob() during an insert earlier.

When I fetch the row the CLOB column just contains trash but not the contents of the test.xml file.

Any idea why ?

Andreas Jung

-- 
                                _\\|//_
                               (' O-O ')
------------------------------ooO-(_)-Ooo--------------------------------------
   Andreas Jung, Saarbrücker Zeitung Verlag und Druckerei GmbH
   Saarbrücker Daten-Innovations-Center
   Untertürkheimerstraße 15, D-66103 Saarbrücken, Germany
   Phone: +49-(0)681-502-1528, Fax: +49-(0)681-502-1509
   Email: ajung_at_sz-sb.de (PGP key available)
-------------------------------------------------------------------------------