PL/SQL (MOSC)

MOSC Banner

Error in calling DBMS_LOB.LOADBLOBFROMFILE

edited Mar 29, 2013 6:35AM in PL/SQL (MOSC) 3 commentsAnswered ✓
Hi,

I have the following piece of code

DECLARE
  F_lob BFILE;
  B_lob BLOB;
  dest_offsetX INTEGER;
  src_offsetX  INTEGER;
BEGIN
  F_lob := BFILENAME('TEMP','Test.pdf');
  INSERT INTO ioldp VALUES(null,sysdate,1,1);
  dest_offsetX := 1;
  src_offsetX := 1;
  DBMS_LOB.LOADBLOBFROMFILE (B_lob,F_lob,DBMS_LOB.LOBMAXSIZE,dest_offsetX,src_offsetX);
  UPDATE ioldp SET dataioldp = B_lob WHERE ioldpid = 1;
  COMMIT;
END;
/

What I want to do is read binary data from a file and then transfer it to a BLOB attribute in a table.

I get the following error, it is on the line where DBMS_LOB.LOADBLOBFROMFILE is called.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center