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 >