with the code TimHall given, I got error with below lines
ERROR at line 17:Code:dbms_lob.loadFromFile(dest_lob => l_clob, src_lob => l_bfile, amount => dbms_lob.getLength(l_bfile));
ORA-06550: line 17, column 3:
PLS-00306: wrong number or types of arguments in call to 'LOADFROMFILE'
When I changed the line to
I got errorCode:dbms_lob.loadFromFile(l_clob, l_bfile, dbms_lob.getLength(l_bfile),1,1);
ERROR at line 35:
ORA-06550: line 35, column 45:
PLS-00306: wrong number or types of arguments in call to 'MAKENODE'
Is this something not installed on my database ?
regards,
Sudhi




Reply With Quote