SQL> CREATE TABLE myTable (
2 id INTEGER PRIMARY KEY,
3 blob_column BLOB NOT NULL
4 );
Table created.
SQL>
SQL>
SQL> CREATE OR REPLACE PROCEDURE initialize_blob(blob_par IN OUT BLOB,id_par IN INTEGER)IS
2 BEGIN
3 SELECT blob_column
4 INTO blob_par
5 FROM myTable
6 WHERE id = id_par;
7 END initialize_blob;
8 /
Procedure created.
SQL>
SQL> drop table myTable;
Table dropped.