Calling Stored Procedures of Oracle in php
| From: | Ketan Parekh | Date: | Fri, 06 Jun 2003 14:24:09 +0000 |
| Subject: | Calling Stored Procedures of Oracle in php | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28371@lists.php.net to get a copy of this message | ||
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