this chunk of code comes out of
http://www.php.net/manual/en/function.ocinewcursor.php
<?php
// suppose your stored procedure info.output returns a ref cursor in :data
$conn = OCILogon("scott","tiger");
$curs = OCINewCursor($conn);
$stmt = OCIParse($conn,"begin info.output(:data); end;");
ocibindbyname($stmt,"data",&$curs,-1,OCI_B_CURSOR);
ociexecute($stmt);
ociexecute($curs);
while (OCIFetchInto($curs,&$data)) {
var_dump($data);
}
OCIFreeCursor($stmt);
OCIFreeStatement($curs);
OCILogoff($conn);
?>
Hope that helps, I havn't gone there (yet).
""Richard S. Crawford"" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Ah! My bad! I sent this question out with the wrong subject line. My
> apologies to everyone that I confused.
>
>
> At 01:07 PM 3/7/01 -0800, Richard S. Crawford wrote:
>
>
> >I desperately need to know whether it is possible to call an Oracle
> >function in PHP. For example...
> >
> >$functionResult=hubins($name,$commit_yn)
> >
> >where hubins is a stored procedure in our Oracle database.
> >
> >Can this be done? My first thought was to do something like this:
> >
> >$functionCall="hubins($name,$commit_yen)";
> >
> >then then do
> >
> >ociexecute($functionCall);
> >
> >...but that, of course didn't work.
> >
> >Any thoughts?
> >
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: [EMAIL PROTECTED]
> >For additional commands, e-mail: [EMAIL PROTECTED]
> >To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
>
> --
> http://www.mossroot.com/index.php
> AIM Handle: Buffalo2K
> e-mail: [EMAIL PROTECTED]
> "When you lose the power to laugh at yourself, you lose the power to think
> straight." --Clarence Darrow
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
