Calling Stored Procedures of Oracle in php

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux