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

2003-06-06 Thread Gary . Every 
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

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