update BLOB
Hello,
version oracle 112
I was testing the following script to update a blob-type column but it didn't work.
DECLARE
l_bfile BFILE;
l_blob BLOB;
BEGIN
SELECT DOCUMENT_FILE
INTO l_blob
FROM table
WHERE SEQUENCE=12345
FOR UPDATE;
l_bfile := BFILENAME ('BACKUPS', TEXT.log');
DBMS_LOB.fileopen(l_bfile, Dbms_Lob.File_Readonly);
DBMS_LOB.loadfromfile(l_blob,l_bfile,DBMS_LOB.getlength(l_bfile));
DBMS_LOB.fileclose(l_bfile);
END;
/
ORA-01403: no data found
ORA-06512: en línea 5
Can you help me please telling me how I can achieve this?
Thanks.
version oracle 112
I was testing the following script to update a blob-type column but it didn't work.
DECLARE
l_bfile BFILE;
l_blob BLOB;
BEGIN
SELECT DOCUMENT_FILE
INTO l_blob
FROM table
WHERE SEQUENCE=12345
FOR UPDATE;
l_bfile := BFILENAME ('BACKUPS', TEXT.log');
DBMS_LOB.fileopen(l_bfile, Dbms_Lob.File_Readonly);
DBMS_LOB.loadfromfile(l_blob,l_bfile,DBMS_LOB.getlength(l_bfile));
DBMS_LOB.fileclose(l_bfile);
END;
/
ORA-01403: no data found
ORA-06512: en línea 5
Can you help me please telling me how I can achieve this?
Thanks.
0