[Zope-dev] Calling a stored function with the Oracle DA

Jim Cain jec@mgmt-inc.com
Thu, 06 Jan 2000 22:27:46 -0500


All,

The "begin procedure (x, y, ..); end;" syntax works for procedures okay,
but how do I call a function? The typical quick & dirty way in sqlplus is

variable x number	-- or whatever
begin
:x := function (a, b, ...);
end;

This function actually does updating, so I can't use the pragmas to make it
acceptable in a select.

Thanks,
Jim