[Zope] Oracle Stored Procedures

Ricardo Seghizzi ricardo@cnbe.mar.org.uk
Fri, 10 Aug 2001 09:20:06 +0100


This is a multi-part message in MIME format.

------=_NextPart_000_00C0_01C1217D.A5157500
Content-Type: text/plain;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

Hi=20

Does anyone knows how to receive a Refence Cursor variable from

a stored procedue?  If a stored Procedure get a result set in a query=20

and I want to pass this resul set as output from my ZSP how do I do it?

How can I do it in Zope. I saw some examples in Python by I don't know =
how to

do it from zope.

TIA

Ricardo=20

------=_NextPart_000_00C0_01C1217D.A5157500
Content-Type: text/html;
	charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Dwindows-1252" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi </FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Does anyone knows how to receive a =
Refence Cursor=20
variable from</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>a stored procedue?&nbsp; If a stored =
Procedure get=20
a result set in a query&nbsp;</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>and&nbsp;I want&nbsp;to pass this resul =
set as=20
output from my ZSP how do I do it?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>How can I do it in Zope. I saw some =
examples in=20
Python by I don't know how to</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>do it from zope.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>TIA</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial =
size=3D2>Ricardo</FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_00C0_01C1217D.A5157500--