Posted by Andy Hassall on 11/16/65 11:29

On Mon, 17 Oct 2005 13:38:02 -0400, "paddy_nyr" <mpprpp@yahoo.com> wrote:

>What is the correct syntax for calling an oracle stored procedure and
>getting a retrun value? I created a simple procedure on my oracle database
>for testing and yes I know I could do this in a function but I have a more
>complex procedure that I have created for the creation of reports. I'm
>trying to use ora_parse and ora_bind without much luck.

Don't use them, they're the (very) old API.

There's an example of calling a stored procedure on the OCI8 manual page.

If you're using ADODB then see http://phplens.com/lens/adodb/docs-oracle.htm
--
Andy Hassall :: andy@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[Back to original message]