Biding Arrays from Oracle Stored Procedure to PHP Variables
| From: | Gregory Watson | Date: | Thu, 29 May 2003 02:39:40 +0000 |
| Subject: | Biding Arrays from Oracle Stored Procedure to PHP Variables | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-149328@lists.php.net to get a copy of this message | ||
Hi guys...
I'm very new to using Oracle and stored procedures.
I'm using a stored procedure to return 12 variables, 8 of which are arrays.
<?php
$EventID = 41403;
$BufferSize = 3000;
$connection_oracle = OCILogon("****","******", "******");
$statement_oracle = OCIParse($connection_oracle, "BEGIN
CFADMIN.getRewardUserList(:in_eventid, :out_status,
:out_record_count, :in_buffersize, :out_memberid, :out_firstname,
:out_lastname, :out_city, :out_state, :out_loginid, :out_email,
:out_redeemstatus); END;");
OCIBindByName($statement_oracle, ":in_eventid", $EventID, -1);
OCIBindByName($statement_oracle, ":out_status", $Status, -1);
OCIBindByName($statement_oracle, ":out_record_count", $RecordCount, -1);
OCIBindByName($statement_oracle, ":in_buffersize", $BufferSize, -1);
OCIBindByName($statement_oracle, ":out_memberid", $MemberID, -1,
OCI_ASSOC);
OCIBindByName($statement_oracle, ":out_firstname", $FirstName, -1,
OCI_ASSOC);
OCIBindByName($statement_oracle, ":out_lastname", $LastName, -1,
OCI_ASSOC);
OCIBindByName($statement_oracle, ":out_city", $City, -1, OCI_ASSOC);
OCIBindByName($statement_oracle, ":out_state", $State, -1, OCI_ASSOC);
OCIBindByName($statement_oracle, ":out_loginid", $LoginID, -1,
OCI_ASSOC);
OCIBindByName($statement_oracle, ":out_email", $Email, -1, OCI_ASSOC);
OCIBindByName($statement_oracle, ":out_redeemstatus", $RedeemStatus,
-1, OCI_ASSOC);
OCIExecute($statement_oracle, OCI_DEFAULT);
OCIFreeStatement($statement_oracle);
OCILogOff($connection_oracle);
?>
I keep getting the following error:
Warning: OCIStmtExecute: ORA-06550: line 1, column 7: PLS-00306:
wrong number or types of arguments in call to 'GETREWARDUSERLIST'
ORA-06550: line 1, column 7: PL/SQL: Statement ignored in
C:\ftp_dir\boards\winners.php on line 22
I know I'm not binding them correctly, but I've looked all over the PHP site and I can't seem to find anything that makes any sense in what to do! Can anyone help?
Thanks in advance!
Greg