DB and Oracle q?
| From: | Vitaly N. Kravchenko | Date: | Thu, 08 Aug 2002 08:33:15 +0000 |
| Subject: | DB and Oracle q? | ||
| Groups: | php.pear.dev | ||
| Request: | Send a blank email to pear-dev+get-8237@lists.php.net to get a copy of this message | ||
Hi people.
Need help.
Here is example from PHP manual:
$sth = OCIParse ( $dbh, "begin sp_newaddress( :address_id,
'$firstname', '$lastname', '$company', '$address1',
'$address2', '$city',
'$state', '$postalcode', '$country', :error_code );end;" );
This calls stored procedure sp_newaddress, with :address_id being an
in/out variable and :error_code being an out variable. Then you do the
binding:
OCIBindByName ( $sth, ":address_id", $addr_id, 10 );
OCIBindByName ( $sth, ":error_code", $errorcode, 10 );
OCIExecute ( $sth );
Ho I can do it with PEAR::DB?
Thank you very much.
--
Best regards, KVN.
PHP4You (<http://php4you.kiev.ua/>)
PEAR [ru] (<http://pear.php.net/manual/ru/>)
mailto:kvn@php.net