php-windows Digest 4 Dec 2005 13:19:21 -0000 Issue 2845
Topics (messages 26570 through 26571):
Re: Access violation
26570 by: El Bekko
PHP Calling Packaged Oracle Stored Procedure
26571 by: Alf Stockton
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin Message ---
Fawaz Shareef wrote:
Hi,
I have installed php 5.1.1, IIS 5 and MySQL 4.1.7 and I am getting the
following error every now and then.
"PHP has encountered an Access Violation at 77FCCAAF"
Sometimes I am able to view php files but most of the times I get this
error and php hangs. Can anyone help
Fawaz
____________________________________________________
Learn real skills for the real world - Apply online
at http://www.ucol.ac.nz or call 0800 GO UCOL
(0800 46 8265) or txt free 3388 for more information
and make a good move to UCOL – Universal College of
Learning.
Enrol with a public institute and be certain of your
future
____________________________________________________
Get apache?
--- End Message ---
--- Begin 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
--- End Message ---
