!!! Problem with BLOB and rwdbblob type in roguewave !!!

From: olivier <odi_at_microresearch.be>
Date: 19 Jul 2002 11:04:47 GMT
Message-ID: <2002719-12447-235052_at_foorum.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 ?  

--

Use our news server 'news.foorum.com' from anywhere. More details at: http://nnrpinfo.go.foorum.com/ Received on Fri Jul 19 2002 - 13:04:47 CEST