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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
