[Zope] RE: Calling a stored function with the Oracle DA

From: Jim Cain

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.

"begin :x := function(:a,:b); end;" where :x, :a and :b are SQL bind variables. This is OCI's syntax. I suppose DCOracle accepts this syntax. You may use literals instead of :a or :b if they are IN arguments. NM