[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 )