Home » RDBMS Server » Server Administration » About DBMS_LOB.LOADFROMFILE.
About DBMS_LOB.LOADFROMFILE. [message #369265] Fri, 28 July 2000 03:31
Sanjay
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('Size:'||to_char(dbms_lob.getlength(img_file)));

DBMS_LOB.LOADFROMFILE(lobd,img_file,f_size);
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
Sanjay
Previous Topic: conflicting queries for Oracle 7.3.4 databases
Next Topic: About table and Column Comments
Goto Forum:
  


Current Time: Fri Mar 29 09:44:47 CDT 2024