OCCI BlobData address pass to a stored procedure (PL/SQL)

Hi,

I'm running on Solaris 64 bit, Oracle 10.2.0.5. I receive a "const unsigned char*" blob that needs to be inserted/updated. I have the following OCCI that

works fine. I need to change it so that it calls a store procedure to perform the update/insert. I need to change the code so that the user only has

execute permissions to the PL/SQL package - using definers rights. Currently the user needs insert, update, dalete, select permissions to the table(s).

int MyDb::setRec(const char* Id, const unsigned char* blobData, const long bufSize)
{
   Blob blob;
   int bystesWritten = 0;
   int offset = 1;