[Orclib-users] Using BLOB objects as stored procedure in/out parameter

[Peter O. <p.n...@gm...>]

Hello,

I've been trying to send and receive BLOB typed parameter to/from a stored
procedure, but i constantly receive 'ORA-24801: illegal parameter value in
OCI lob function' exception.

For the input part, i use the Blob class this way:

Blob blob(con);
blob.Write(data_to_send);
blob.Seek(ocilib:SeekSet, 0); // i've just tried everything :)
stmt.Bind(":P_NAME", blob, BindInfo::In);

Code for the output param:

Blob oBlob(con);
stmt.Bind(":PO_NAME", oBlob, BindInfo::Out);

Then i execute the prepared statement as usual.

Clearly i'm using something in an improper manner...

Thanks in advance,
Peter