OraFAQ Forum: Server Administration » About DBMS

Home » RDBMS Server » Server Administration » About DBMS_LOB.LOADFROMFILE.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	conflicting queries for Oracle 7.3.4 databases
Next Topic:	About table and Column Comments

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 02:11:35 CST 2025