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

[Nemeth Miklos]

> 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

>
>