If this is a cut-n-paste of the code, check the line below for spelling:
"begin prcoedurename('support@try.com','3');end;";
^^^
Gary Every
Sr. UNIX Administrator
Ingram Entertainment
(615) 287-4876
"Pay It Forward"
mailto:gary.every@ingramentertainment.com
http://accessingram.com
> -----Original Message-----
> From: Ketan Parekh [mailto:ketanp@cybage.com]
> Sent: Friday, June 06, 2003 9:24 AM
> To: php-db@lists.php.net
> Subject: 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('support@try.com','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
>
