Error in calling DBMS_LOB.LOADBLOBFROMFILE
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.