[PHP-DB] Calling Stored Procedures of Oracle in php

2003-06-06 Thread Ketan Parekh 
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

Re: [PHP-DB] Calling Stored Procedures of Oracle in php

2003-06-06 Thread Ketan Parekh 
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