Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Stored Proc with Cursor Param
Geoff wrote:
> Hello,
>
> I am trying to call a stored proc which has one in/out param, a ref cursor.
> I noticed in the C examples, they declare a cda_def, and use that in the
> call to the stored proc.
>
> I am using smalltalk at the moment, so, to achieve the same effect, would I
> need to allocate memory, the size of a cda_def struct and pass that into the
> stored proc or is there some other way to do that?
>
> I am using Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 -
> Production with the Partitioning, OLAP and Data Mining options, Release 2,
> on Win XP.
>
> Thanks.
>
> -g
>
>
>I am trying to call a stored proc which has one in/out param, a ref >cursor.I noticed in the C examples, they declare a cda_def, and use >that in the call to the stored proc.
I'm not sure of the cda_def structure. But using OCI, calling a stored procedure is straight forward. The ref cursor should be bound (OCIBindByPos) as a resultset type SQLT_RSET.
Check the documentation of how REF CURSORS can be implmented
in OCI:
http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14250/oci05bnd.htm#sthref795
Rgds.
Amogh
Received on Fri May 26 2006 - 09:37:07 CDT