note 2115 deleted from function.oci-parse by sixd
| From: | sixd@php.net | Date: | Wed, 11 Nov 2009 17:58:13 +0000 |
| Subject: | note 2115 deleted from function.oci-parse by sixd | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-162771@lists.php.net to get a copy of this message | ||
Note Submitter: webmaster at remoterealty dot com
----
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!