Stored Proc with Cursor Param

From: Geoff <nospam_at_nospam.com>
Date: Thu, 25 May 2006 23:14:09 GMT
Message-ID: <5Tqdg.7709$y4.4366@newsread2.news.pas.earthlink.net>

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 Received on Thu May 25 2006 - 18:14:09 CDT