RE: [PHP-DB] Calling Stored Procedures of Oracle in phpYou did not get it. Actually
the procedure name means Any procedure Name say "getName". It was just an example :-)
----- Original Message -----
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Friday, June 06, 2003 9:00 PM
Subject: RE: [PHP-DB] Calling Stored Procedures of Oracle in php
If this is a cut-n-paste of the code, check the line below for spelling:
"begin prcoedurename('[EMAIL PROTECTED]','3');end;";
^^^
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:[EMAIL PROTECTED]
http://accessingram.com
> -----Original Message-----
> From: Ketan Parekh [mailto:[EMAIL PROTECTED]
> Sent: Friday, June 06, 2003 9:24 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Calling Stored Procedures of Oracle in php
>
>
> Hi,
>
> I want to call a oracle stored procedure from php and
> retrieve the values.
> My procedure has 2 parameters which i have to pass and based
> on that it will
> return values. I am using the below code. I am getting errors
> like wrong
> arguements passed. Can anybody tell me the reason?
>
> $conn = ora_logon("abc","xyz");
> $curs = ora_open($conn);
> $query = "begin prcoedurename('[EMAIL PROTECTED]','3');end;";
>
> ora_parse($curs, $query);
> ora_exec($curs);
> ora_fetch($curs);
>
> $nrows = ora_numrows($curs);
> echo $nrows;
> exit;
>
> --
>
> Thanks,
>
> Ketan Parekh
> -----------------------------------------
> Cybage Software Pvt Ltd.
> 6686359 Ext 235
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
