Loading CLOB and BLOB data
I am using the text book “Oracle Database 10g PL/SQL Programming”
In Chapter 16 (page753), I am running the script to insert CLOB and BLOB data into the table using the LOADFROMFILE.
However, I am getting the following error message:
ORA-22289: cannot perform operation on an unopened file or LOB
ORA-06512: at "SYS.DBMS_LOB", line 592
ORA-06512: at line 53
ORA-22288: file or LOB operation FILEOPEN failed
The system cannot find the path specified.
22289. 00000 - "cannot perform %s operation on an unopened file or LOB"
I know the data is there. I created my own table,directory, and I tried loading my own data and I still get the same errors.
I am on a windows machine using Oracle 11g
Any information will be helpful. Thanks!