note 2115 modified in function.ociparse by danbrown
| From: | danbrown@php.net | Date: | Wed, 25 Feb 2009 14:11:39 +0000 |
| Subject: | note 2115 modified in function.ociparse by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-151113@lists.php.net to get a copy of this message | ||
This calls stored procedure sp_newaddress, with :address_id being an in/out variable and :error_code
being an out variable.
<?php
$sth = OCIParse ( $dbh, "begin sp_newaddress( :address_id, '$firstname',
'$lastname', '$company', '$address1', '$address2',
'$city', '$state', '$postalcode', '$country', :error_code
);end;" );
?>
Then you do the binding:
<?php
OCIBindByName ( $sth, ":address_id", $addr_id, 10 );
OCIBindByName ( $sth, ":error_code", $errorcode, 10 );
OCIExecute ( $sth );
?>
Hope this helps!
--was--
$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 );
Hope this helps!
http://php.net/manual/en/function.ociparse.php