PHP Calling Packaged Oracle Stored Procedure

From: Date: Sun, 04 Dec 2005 13:19:10 +0000
Subject: PHP Calling Packaged Oracle Stored Procedure
Groups: php.windows 
Request: Send a blank email to php-windows+get-26571@lists.php.net to get a copy of this message
I am failing in an attempt to access an Oracle database using the following php. The calls I have tested are as follows:- $query = "begin spPackage.spMemberDetails(:p_number,:cv_memberdetails); end;"; $stmt = OCIParse($conn, $query )
        or die('Cannot parse query');
OCIBindByName($stmt,":p_number",$number, -1)
        or die('First cannot bind variable');
OCIBindByName($stmt, ":cv_memberdetails", &$array, -1)
        or die('Second cannot bind variable');
$query = "begin spPackage.spMemberDetails(:p_number); end;"; $stmt = OCIParse($conn, $query )
        or die('Cannot parse query');
OCIBindByName($stmt,":p_number",$number, -1)
        or die('First cannot bind variable');
I get the following error message:- ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SPMEMBERDETAILS' ORA-06550: line 1, column 7: PL/SQL: Statement ignored begin spPackage.spMemberDetails(:p_number); end;
      ^
The 1st part of the stored procedure I am trying to use is as follows:- CREATE OR REPLACE PACKAGE "BIG"."SPPACKAGE" AS type memberdetail_type is record (
       r_mem_number members.mem_number%type, 
       r_mem_sname  members.mem_sname%type, 
       r_mem_fname  members.mem_fname%type, 
       r_mem_title  members.mem_title%type); 
  type memberdetail_cur_type is ref cursor return memberdetail_type; 
PROCEDURE spMemberDetails( p_number cards.card_number%type, --varchar2 cv_memberdetails out memberdetail_cur_type); Please tell me what I am not understanding and where I have gone wrong. BTW I did not write the stored procedure. -- Regards, Alf Stockton www.stockton.co.za Linux 2.6.12-10-386 You will pioneer the first Martian colony. My email disclaimer is available at www.stockton.co.za/disclaimer.html

« previous php.windows (#26571) next »