PL/SQL (MOSC)

MOSC Banner

update BLOB

edited Jul 25, 2012 2:53AM in PL/SQL (MOSC) 5 commentsAnswered
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.

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