Insert into returning to blob type variable : BLOB « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. BLOB

SQL> CREATE TABLE myBlob
  2  (id NUMBER PRIMARY KEY,
  3   blob_data BLOB);

Table created.

SQL>
SQL>
SQL> DECLARE
  2    blobValue BLOB;
  3  BEGIN
  4    INSERT INTO myBlob VALUES (4,HEXTORAW('AAAAAAAAAAAAAAAAAAAA'))
  5    RETURNING blob_data INTO blobValue;
  6
  7  END;
  8  /

PL/SQL procedure successfully completed.

SQL>
SQL> drop table myBlob;

Table dropped.

SQL>