[Zope] Oracle Stored Procedures

ender kthangavelu@earthlink.net
Fri, 20 Apr 2001 04:54:30 -0700


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