SQL>
SQL> CREATE TABLE myBlob
2 (id NUMBER PRIMARY KEY,
3 blob_data BLOB);
Table created.
SQL> DECLARE
2 blobValue BLOB;
3 BEGIN
4 INSERT INTO myBlob VALUES (3,HEXTORAW('AAAAAAAAAAAAAAAAAAAA'));
5 SELECT blob_data
6 INTO blobValue
7 FROM myBlob
8 WHERE id =3;
9
10 END;
11 /
PL/SQL procedure successfully completed.
SQL>
SQL> drop table myBlob;
Table dropped.
SQL>