[Zope] Oracle Stored Procedures

Andreas Jung andreas@digicool.com
Fri, 20 Apr 2001 15:52:59 -0400


That's right. As a workaround you can put the calls
for the stored procedures into an external method
or a PythonScript....never tried it but it should work.

Andreas
----- Original Message -----
From: "Dario Lopez-Kästen" <dario@ita.chalmers.se>
To: "Andreas Jung" <andreas@digicool.com>
Cc: <zope@zope.org>
Sent: Friday, April 20, 2001 3:34 PM
Subject: Re: [Zope] Oracle Stored Procedures


> From: "Andreas Jung" <andreas@digicool.com>
> Subject: Re: [Zope] Oracle Stored Procedures
> > Of course it is Zope specific. An Oracle stored procedure (returning
> > a value) acting as a function can be used without any problem inside
> > a select statement. But there is no call interface to support stored
> > procedures without return value. When your stored procedure only uses
> > IN parameters you could rewrite it as a function.
> >
> > Andreas Jung
> > Digitial Creations
>
> So are you saying that stored procedures only can be used in the context
of
> an SQL statemnt from Zope (in effect only from ZSQL methods?).
>
> If so, is this the case with version 1 or 2 of the DCOracle product? or
> both?
>
> /dario - expecting the worst... :-/
>
> - --------------------------------------------------------------------
> Dario Lopez-Kästen     Systems Developer  Chalmers Univ. of Technology
> dario@ita.chalmers.se  ICQ: 14142275 (seldom)    IT Systems & Services
>
>
>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )