create table testblob (int_col integer, blob_col blob)

create PROCEDURE spp (IN INT_P INTEGER, INOUT BLOB_P BLOB)

P1:  BEGIN INSERT INTO testblob(INT_COL, BLOB_COL) values (INT_P, BLOB_P);

SELECT BLOB_COL INTO BLOB_P FROM testblob WHERE INT_COL = INT_P;

END P1