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>
|