Hi,
I am just testing ODBC access to an Oracle Database through PhP. I am able to execute an SQL command, run an Oracle procedure, using the syntax odbc_exec($id, "{call myproc('myparam')}).
But I do not know how to execute an oracle function.
I have used odbc_procedurecolumns to obtain the list of procedures and functions existing on the Oracle server. So I see that the functions have an unnamed parameter corresponding to the return value.
Now my problem is to find the ODBC syntax to call the function and obtain the return value. Any idea?
Thanks for your help.
Best regards.
I am just testing ODBC access to an Oracle Database through PhP. I am able to execute an SQL command, run an Oracle procedure, using the syntax odbc_exec($id, "{call myproc('myparam')}).
But I do not know how to execute an oracle function.
I have used odbc_procedurecolumns to obtain the list of procedures and functions existing on the Oracle server. So I see that the functions have an unnamed parameter corresponding to the return value.
Now my problem is to find the ODBC syntax to call the function and obtain the return value. Any idea?
Thanks for your help.
Best regards.