[Zope] Oracle Stored Procedures

Dario Lopez-Kästen dario@ita.chalmers.se
Fri, 20 Apr 2001 21:34:27 +0200


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