[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-windows
Subject:    [PHP-WIN] PHP Calling Packaged Oracle Stored Procedure
From:       Alf Stockton <alf () stockton ! co ! za>
Date:       2005-12-04 13:19:10
Message-ID: 4392ECCE.6050807 () stockton ! co ! za
[Download RAW message or body]

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

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[prev in list] [next in list] [prev in thread] [next in thread]