Home » RDBMS Server » Server Administration » About DBMS_LOB.LOADFROMFILE.
About DBMS_LOB.LOADFROMFILE. [message #369265] Fri, 28 July 2000 03:31
Messages: 236
Registered: July 2000
Senior Member
I am getting a error message "ORA-6502. numberic or value error."

The script as follows ..
img_file := BFILENAME('LOB_DIR',tmp_file);
dbms_output.put_line('bfilename passed');

DBMS_LOB.FILEOPEN(img_file, dbms_lob.file_readonly);
dbms_output.put_line('fileopen passed');


dbms_output.put_line('loadfromfile passed');


So when it come to LOADFROMFILE statement I am getting the above error ... can anyone answer me please how to debug this ..

Thanks in Advance
Previous Topic: conflicting queries for Oracle 7.3.4 databases
Next Topic: About table and Column Comments
Goto Forum:

Current Time: Sat Oct 24 04:50:48 CDT 2020