SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

invalid LOB locator specified: ORA-22275

siegwin.portApr 7 2016 — edited Apr 7 2016

Hi,

I tried to create a simple procedure an read a picture file into a procedure BLOB.

CREATE OR REPLACE PROCEDURE read_lob_from_file_p

n_length NUMBER;

ziel BLOB;

fils BFILE := BFILENAME('TEMP_DIR','Foto0027.jpg');

BEGIN

dbms_lob.fileopen(fils,dbms_lob.file_readonly);

n_length := dbms_lob.getlength(fils);

DBMS_LOB.LOADFROMFILE (ziel,fils,n_length);

-- COMMIT;

dbms_lob.fileclose(fils);

END;

In line 9 (DBMS_LOB.LOADFROMFILE (ziel,fils,n_length);) I got the error invalid LOB locator specified: ORA-22275

Can anyone help me?

Regards

Siegwin

This post has been answered by odie_63 on Apr 7 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2016

Added on Apr 7 2016

2 comments

983 views