Hm. Assuming that I don't have the option of rewriting the function to a
procedure, is there another way to go?
At 10:54 PM 3/7/01 +0100, Matthias Kopolt wrote:
>Oracle Divides Function in several Groups
>
>DML means Data-Manipulating function;
>
>(in your funciton is a update or insert)
>
>to
dure needs to declare the second argument as in and can declare the
second one as "out" or "in out"
mk
-Ursprungliche Nachricht-
Von: Richard S. Crawford [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 7. Marz 2001 22:46
An: [EMAIL PROTECTED]
Betreff: Re: AW: [PHP-DB] Orac
Here is the error that I get when I try this approach:
ORA-14551: cannot perform a DML operation inside a query
At 10:26 PM 3/7/01 +0100, Matthias Kopolt wrote:
>YOu have to form proper SQL-Statements
>
>try to parse and execute:
>
> select foo_function ('paramstr', 999) from dual;
>
>
YOu have to form proper SQL-Statements
try to parse and execute:
select foo_function ('paramstr', 999) from dual;
dual is a dummy table;
then fetch the resultrow and ociresult($stmt, 1) will return your
functionreturnvalue
mk
-Ursprungliche Nachricht-
Von: Richard S. Crawfo
