Problem with RWDBBlob type in roguewave

From: olivier <odi_at_microresearch.be>
Date: 19 Jul 2002 05:01:09 -0700
Message-ID: <7413cdbe.0207190401.69432c9@posting.google.com>

Hello

We have here a problem with the Oracle Blob type and the roguewave RWDBBlob type.

We have the following stored procedure in Oracle 8.1.7.

--

• procedure sql
  --
  PROCEDURE MY_set_blob(par_blob blob) is BEGIN insert into gar.blob_test(col_blob) values(par_blob); commit; END;

And we have a C++ Program with this part :
--

• program C++
  --
  ................ RWDBStoredProc proc=db.storedProc("gar.MY_set_blob"); RWDBBlob my_blob;

       proc[0] << my_blob; 			
       
       RWDBResult  result = proc.execute();
.....................

The compilation of the C++ program goes well but when we execute it, we have this error

Stored procedure gar.MY_set_blob found
[SERVERMESSAGE] ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'MY_SET_BLOB' ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
--

• !!!!!!!!!!!!!!!!!!!!!!!!
  --
  

Any suggestion on hwo we can solve the problem ? Received on Fri Jul 19 2002 - 07:01:09 CDT