Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Execute a function through ODBC

Status
Not open for further replies.

Xyalis

Programmer
May 7, 2009
1
FR
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top