[Zope-DB] DCOracle2 with a Stored Procedure that Returns a ref_cur
Matthew T. Kromer
matt at bane.mi.org
Tue Mar 20 21:17:30 EDT 2007
If I recall, DCOracle2 returns an array of the OUT parameters from
invoking a stored procedure, so your invocation would be more like
c2 = c1.sp1(in1, in2, in3, in4) and you wouldn't pass in ref_cur
but its been a while since I reviewed the code. I know ref cursors
used to work...
On Mar 16, 2007, at 11:44 AM, Maan M. Hamze wrote:
> I am using DCOCralce2 with Python 2.41, and Oracle 9.
> I have a stored procedure (sp1) that takes 4 IN parameters, with
> one OUT
> parameter. The OUT parameter is a **ref_cursor** that holds a data
> I am doing the following:
> db = DCOracle2.connection(connectionString)
> C1 = db.cursor()
> C2 = db.cursor()
> #I run the following holding the result into the cursor C2
> #since the OUT param is a ref_cur
> C2 = C1.sp1(INparam1, INparam2,INparam3,INparam4, ref_cur)
> I expect to get a data set
> I know there is data when sp1 is run
> But I am getting an empty data set when I fetch data via C2 cursor.
> Do you have any idea how to make this work when a stored procedure
> has a
> ref_cur OUT parameter?
> Zope-DB mailing list
> Zope-DB at zope.org
More information about the Zope-DB