[Zope] Oracle Stored Procedures

[Andreas Jung]

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
----- Original Message -----
From: "ender" <kthangavelu@earthlink.net>
To: "Alejandro Pancani" <apancani@topgroup.com.ar>; <zope@zope.org>
Sent: Friday, April 20, 2001 7:54 AM
Subject: Re: [Zope] Oracle Stored Procedures


> On Friday 20 April 2001 11:07, Alejandro Pancani wrote:
> >>I wonder if anybody know how to call a stored procedure from Zope
> >>
> >>I have an Oracle 8i Database conected to zope with Z Oracle DA Product
>
> procedure not function, right?
>
> i don't think this is zope specific, but generally with a procedure called
> from the client side you need to wrap it in an anonymous pl/sql block or a
> function (called from a select).
>
> begin
>      you_proc(args)
> end;
>
>
> kapil
>
> _______________________________________________
> 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 )