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 )