Re: Problem with RWDBBlob type in roguewave

olivier wrote:

> 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 ?

You can not insert a BLOB as you are trying.

Perhaps the following snippets will give you the clues you need.

• insert a NULL record to lock INSERT INTO lob_demo (file_name, image) VALUES (fname, EMPTY_BLOB()) RETURNING image INTO dst_file;
• lock record SELECT image INTO dst_file FROM lob_demo WHERE file_name = fname FOR UPDATE;
• update the blob field UPDATE lob_demo SET image = dst_file WHERE file_name = fname;

Daniel Morgan Received on Fri Jul 19 2002 - 11:00:49 CDT