[Sqlrelay-discussion] Problem with oracle returning null values

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi,

I've got a plsql procedure as follows:

PROCEDURE test_null (
          p_return_value    OUT       VARCHAR2
) IS

BEGIN
     p_return_value :=3D NULL;
END;

When executing it through php + sqlrelay, i get the following back as=20
the p_return_value, anyone know what might cause this or how to fix it?

Thanks,
Nathan

Result set:
Result Set Buffer Size:
Opening cached result set:
%s.indSQLRELAYCACHEFile  is either corrupt or not a cache file.Couldn't=20
open  and %s.indCaching data to
Resuming caching data to SQLRELAYCACHEError caching data to Finishing=20
caching.
Resuming Result Set of Cursor:
The query is too large.  MAXQUERYSIZE is
File name / is too long.File: The file  could not be opened.
The query in  is too large. No query to execute.'' is NULL $(-- debug
Sending Query:
Length: Requesting Cursor: Requesting a new cursor.
Requesting re-execution of previous query.Sending  Input Bind Variables:
(:NULL)
:STRING)=3D):LONG)=3D:DOUBLE)=3D:,:BLOB)=3D:CLOB)=3DSending Output Bind V=
ariables:
Send Column Info: yes
Send Column Info: no
Checking For An Error... Failed to determine whether an error occurred=20
or not.
 A network error may have ocurred.none.
error!!!
Getting Cursor ID...
Failed to get a cursor id.
 A network error may have ocurred.Cursor ID:
Failed to determine whether the session was suspended or not.
 A network error may have ocurred.Failed to get the index of the last=20
row of a previously suspended result set.
 A network error may have ocurred.Previous result set was suspended at=20
row index: not suspended.
Getting Error From Server
There was an error, but the connection died trying to retrieve it. =20
Sorry.Setting Error
UNKNOWNCHARINTSMALLINTTINYINTMONEYDATETIMENUMERICDECIMALSMALLDATETIMESMAL=
LMONEYIMAGEBINARYBITREALFLOATTEXTVARCHARVARBINARYLONGCHARLONGBINARYLONGIL=
LEGALSENSITIVITYBOUNDARYVOIDUSHORTUNDEFINEDDOUBLEDATETIMETIMESTAMPUINTLAS=
TREALSTRINGVARSTRINGLONGLONGMEDIUMINTYEARNEWDATENULLENUMSETTINYBLOBMEDIUM=
BLOBLONGBLOBBLOBVARCHAR2NUMBERROWIDRAWLONG_RAWMLSLABELCLOBBFILEBIGINTINTE=
GERLONGVARBINARYLONGVARCHARGRAPHICVARGRAPHICLONGVARGRAPHICDBCLOBDATALINKU=
SER_DEFINED_TYPESHORT_DATATYPETINY_DATATYPED_FLOATARRAYQUADINT64DOUBLE=20
PRECISIONBOOLBYTEANAMEINT8INT2INT2VECTORINT4REGPROCOIDTIDXIDCIDOIDVECTORS=
MGRPOINTLSEGPATHBOXPOLYGONLINE_LINEFLOAT4FLOAT8ABSTIMERELTIMETINTERVALCIR=
CLE_CIRCLE_MONEYMACADDRINETCIDR_BOOL_BYTEA_CHAR_NAME_INT2_INT2VECTOR_INT4=
_REGPROC_TEXT_oid_TID_XID_CID_OIDVECTOR_BPCHAR_VARCHAR_INT8_POINT_LSEG_PA=
TH_BOX_FLOAT4_FLOAT8_ABSTIME_RELTIME_TINTERVAL_POLYGONACLITEM_ACLITEM_MAC=
ADDR_INET_CIDRBPCHAR_TIMESTAMP_DATE_TIMETIMESTAMPTZ_TIMESTAMPTZINTERVAL_I=
NTERVAL_NUMERICTIMETZ_TIMETZ_BITVARBIT_VAR
BITREFCURSOR_REFCURSORREGPROCEDUREREGOPERREGOPERATORREGCLASSREGTYPE_REGPR=
OCEDURE_REGOPER_REGOPERATOR_REGCLASS_REGTYPERECORDCSTRINGANYANYARRAYTRIGG=
ERLANGUAGE_HANDLERINTERNALOPAQUEParsing=20
Column Info
Actual row count: Failed to get whether the server knows the number=20
actual rows or not.
 A network error may have occurred.Failed to get the number of actual row=
s.
 A network error may have occurred.unknown
Affected row count: Failed to get whether the server knows the number of=20
affected rows or not.
 A network error may have occurred.Failed to get the number of affected=20
rows.
 A network error may have occurred.Failed to get whether the server is=20
sending column info or not.
 A network error may have occurred.Failed to get the column count.
 A network error may have occurred.Column count: Failed to whether=20
column types will be predefined id's or strings.
 A network error may have occurred.Failed to get the column name length.
 A network error may have occurred.Failed to get the column name.
 A network error may have occurred.Failed to get the column type.
 A network error may have occurred.Failed to get the column type length.
 A network error may have occurred.Failed to get column info.
 A network error may have occurred."",",  (,) NOT NULL Primary Key=20
Unique Part of a Key Unsigned Zero Filled Binary Auto-Increment=20
Receiving Output Bind Values:
Failed to get data type.
 A network error may have occurred.Failed to get string value length.
 A network error may have occurred.Failed to get string value.
 A network error may have occurred.Failed to get cursor id.
 A network error may have occurred.Failed to get total length.
 A network error may have occurred.Failed to get chunk type.
 A network error may have occurred.Failed to get chunk length.
 A network error may have occurred.Failed to get chunk data.
 A network error may have occurred.=3D
Parsing Data
Already at the end of the result set
Failed to get the field type.
 A network error may have occurredGot end of result set.
Creating extra rows.
Failed to get the field length.
 A network error may have occurredFailed to get the field data.
 A network error may have occurredFailed to get total length.
 A network error may have occurredFailed to get chunk type.
 A network error may have occurredFailed to get chunk length.
 A network error may have occurredFailed to get chunk data.
 A network error may have occurred"",,
Skipping and Fetching
    row to get:
Fetching  rows
The cache file index appears to be corrupt.Skipping Aborting Result Set=20
For Cursor:
Getting the rest of the result set, since this is a cached result set.
=01=1B=03;=1B=AD=03=FF=FF$=1B=D0=04=FF=FFL=1B =06=FF=FFt=1Br=08=FF=FFoe=1B=
D
=FF=FF=E0=1B$=0B=FF=FF=1C=1C=0C=FF=FF =1C,=0E=FF=FFD=1C=08=0F=FF=FFd=1C=EC=
=0F=FF=FF"=1C?=12=FF=FF=B0=1C=BE=12=FF=FF=D0=1C=EC=12=FF=FF=F0=1COE=14=FF=
=FF=10=1D"=15=FF=FF0=1D=B0=16=FF=FFP=1D4=17=FF=FFp=1DEUR=17=FF=FF?=1D=D6=17=
=FF=FF=B0=1D,=18=FF=FF=D0=1D"=18=FF=FF=F0=1D=F4=18=FF=FF=10=1E=AE=19=FF=FF=
0=1E~=1A=FF=FFP=1E@=1B=FF=FFt=1E~=1B=FF=FF"=1Eh=1C=FF=FF=B4=1E0=1D=FF=FF=D4=
=1E=0C=1E=FF=FF=F4=1Ef=1E=FF=FF=14=1F=D6=1E=FF=FF4=1F=D0=20
=FF=FFt=1F,#=FF=FF =1FD,=FF=FF=18 x,=FF=FFT =C2/=FF=FF| =0C3=FF=FF=C0 N6=FF=
=FF=E0 =AE9=FF=FF! :=FF=FF=20
!;=FF=FF@!@<=FF=FFd!+<=FF=FF"!=F2<=FF=FF=A4!:=3D=FF=FF=C4!,=3D=FF=FF=E4!=CA=
=3D=FF=FF=04"=1A>=FF=FF$"j>=FF=FFD"=BA>=FF=FFd"
?=FF=FF""Z?=FF=FF=A4"=AA?=FF=FF=C4"=FA?=FF=FF=E4"J@=FF=FF=04#'@=FF=FF$#=FE=
@=FF=FFD#FA=FF=FFd#Z(A=FF=FF"#=D6A=FF=FF=A4#&B=FF=FF=C4#vB=FF=FF=E4#=C6B=FF=
=FF=04$=16C=FF=FF$$fC=FF=FFD$=B6C=FF=FFd$=06D=FF=FF"$VD=FF=FF=A4$=20
D=FF=FF=C4$=10E=FF=FF=E4$EURE=FF=FF=04%,F=FF=FF$%~F=FF=FFD%=D2F=FF=FFd%=EA=
G=FF=FF^%<(B[=FF=FF`(>\=FF=FF"(H]=FF=FF=A8(R^=FF=FF=CC(^_=FF=FF=F0(=10`=FF=
=FF=18)P`=FF=FF<)=C4`=FF=FF`)^a=FF=FF^)=20
b=FF=FF=B0)Lb=FF=FF=D4)vb=FF=FF=F8)=20
b=FF=FF=1C*=CAb=FF=FF@*=0Cf=FF=FFh*=1Cg=FF=FFOE*lg=FF=FF=B0*=BEg=FF=FF=D4=
*Th=FF=FF=F8*=12i=FF=FF=1C+=BCi=FF=FF\+hk=FF=FF|+xl=FF=FF=BC+=D6p=FF=FF=F0=
+=ACq=FF=FF=10,=CCr=FF=FF@,"w=FF=FFt,'w=FF=FF~,=D6w=FF=FF=BC,S({=FF=FF=E0=
,^}=FF=FF=04-&=0C
7;=FF=FF(-=C6?=FF=FFL-=20
EUR=FF=FF^-=D0EUR=FF=FF=A8-=B0,=FF=FF=E8-=E8,=FF=FF=10.B"=FF=FF4.=E60/00=FF=
=FF\.*S(=FF=FF".tS(=FF=FF=C4.=B0S(=FF=FF=E4.=F0S(=FF=FF=04/D<=FF=FFD/=FC?=
=FF=FFOE/=04"=FF=FF=B0/("=FF=FF=F4/=C4"=FF=FF=140j^(TM)=FF=FF40=D4=A4=FF=FF=
T0*=A8=FF=FFt04=A9=FF=FF"0=F0=AA=FF=FF=B40h=AC=FF=FF=D40=CA=AD=FF=FF=F40=B6=
=AF=FF=FF=141=F2=B0=FF=FF81"=B1=FF=FF\14=B2=FF=FF|1=D2=B3=FF=FFoe1B=B4=FF=
=FF=BC1=B2=B4=FF=FF=DC1(=B5=FF=FF=FC1(=C1=FF=FF=20
2=D4=C1=FF=FFD2=C0=C7=FF=FF^2j=CF=FF=FF=AC26=D0&y
uml;=FF=D42=CC=D0=FF=FF=183"=D1=FF=FF83=FA=D1=FF=FFX3p=D4=FF=FFx3L=D5=FF=FF=
~3Z=D6=FF=FF=B83<=D7=FF=FF=D83H=D9=FF=FF=FC3 =DB=FF=FF=1C4=1C=DC=FF=FF@4<=
=DD=FF=FFd4=E0y=01=E0>=01+J=013J=018J=01K=01GK=01QK=01VK=01^K=01cK=01hK=01=
lK=01uK=01EURK=010/00K=01Z(K=01--K=01z(K=01=A4K=01=A8K=01=B1K=01=BAK=01=BF=
K=01=C5K=01=CCK=01=D4K=01=E2K=01=EEK=01=F6K=01=01L=01=10L=01=17L=01=20
L=012L=01AL=01OL=01WL=01]L=01bL=01hL=01yL=01~L=01"L=010/00L=01Z(L=01"L=01=
z(L=01=A3L=01=ABL=01=AFL=01=B3L=01=B7L=01=BBL=01=C5L=01=CAL=01=D0L=01=D5L=
=01=DAL=01=DEL=01=E6L=01=EBL=01=F1L=01=F8L=01=FFL=01=07M=01=0FM=01=19M=01=
=20
M=01(M=01/M=017M=01V=01EV=01OV=01XV=01bV=01gV=01oV=01tV=01yV=01}V=01+V=01=
'V=01s(V=01Y"V=01=A8V=01=AFV=01=B5V=01=B9V=01=C2V=01=CBV=01=D0V=01=D6V=01=
=DDV=01=E5V=01=F3V=01=FFV=01=07W=01=12W=01!W=01(W=011W=01CW=01RW=01`W=01h=
W=01nW=01sW=01yW=01S(W=01?W=01.W=01s(W=01Y"W=01=A4W=01=AFW=01=B4W=01=BCW=01=
=C0W=01=C4W=01=C8W=01=CCW=01=D6W=01=DBW=01=E1W=01=E6W=01=EBW=01=EFW=01=F7=
W=01=FCW=01=02X=01   =20
X=01=10X=01=18X=01 X=01*X=011X=019X=01@X=01HX=01MX=01RX=01XX=01_X=01eX=01=
kX=01qX=01}X=01fX=01OEX=01'X=01--X=01oeX=01=A1X=01=A6X=01=B1X=01=B9X=01=C2=
X=01=C8X=01=CFX=01=D5X=01=DBX=01=E0X=01=E8X=01=F0X=01=F9X=01=02Y=01
Y=01=16Y=01=1EY=01'Y=010Y=016Y=01<=FF=FFd!+<=FF=FF"!=F2<=FF=FF=A4!:=3D'=FF=
=FF=C4!,=3D=FF=FF=E4!=CA=3D=FF=FF=04"=1A' :=FF=FF =AE9=FF=FF! N6=FF=FF=E0=
=20
3=FF=FF=C0 =FF=FF| =C2 x,=FF=FFT =FF=FFt=1F,#=FF=FF =1FD,=FF=FF=18 =1E=FF=
=FF=F4=1Ef=1E=FF=FF=14=1F=D6=1E=FF=FF4=1F=D0 =1C,=0E=FF=FFD=1C=08=0F=FF=FF=
d=1C=EC=0F=FF=FF"=1C?=12=FF=FF=B0=1C=BE=12=FF=FF=D0=1C=EC=12=FF=FF=F0=1CO=
E=14=FF=FF=10=1D"=15=FF=FF0=1D=B0=16=FF=FFP=1D4=17=FF=FFp=1DEUR=17=FF=FF?=
=1D=D6=17=FF=FF=B0=1D,=18=FF=FF=D0=1D"=18=FF=FF=F0=1D=F4=18=FF=FF=10=1E=AE=
=19=FF=FF0=1E~=1A=FF=FFP=1E@=1B=FF=FFt=1E~=1B=FF=FF"=1Eh=1C=FF=FF=B4=1E0=1D=
=FF=FF=D4=1E=20
=FF=FF =FF=FF=1C=1C =FF=FF=E0=1B$ =01=1B=03;=1B=AD=03=FF=FF$=1B=D0=04=FF=FF=
L=1B =06=FF=FFt=1Br
=08=FF=FFoe=1BD set. result cached a is this since set, the of rest Getti=
ng=20
Cursor: For Set Result Aborting corrupt.Skipping be to appears index=20
file cache The rows Fetching get: row and Skipping occurred??,, have may=20
error network A data. chunk get occurredFailed length. type. total field=20
Failed rows. extra Creating end occurredGot set at Already Data=20
occurred.=3D"Parsing" occurred.Failed id. cursor=20
=05Ef=04+=03j.=20
=05Ef=04+=03R.=10$t$=EB=FE=FF=D2=01=047=19A=0E=08...=02B=20
=05Ef=04+=03R.=10$L|=E9=FE=FF=D0=01=04G=19A=0E=08...=02B =04=04^=01$$=D4=E7=
=FE=FF=D0=01=04W=19A=0E=08...=02B>=FF=FF$"j>=FF=FFD"=BA>=FF=FFd"
?=FF=FF""Z?=FF=FF=A4"=AA?=FF=FF=C4"=FA?=FF=FF=E4"J@=FF=FF=04#'@=FF=FF$#=FE=
@=FF=FFD#FA=FF=FFd#Z(A=FF=FF"#=D6A=FF=FF=A4#&B=FF=FF=C4#vB=FF=FF=E4#=C6B=FF=
=FF=04$=16C=FF=FF$$fC=FF=FFD$=B6C=FF=FFd$=06D=FF=FF"$VD=FF=FF=A4$=20
D=FF=FF=C4$=10E=FF=FF=E4$EURE=FF=FF=04%,F=FF=FF$%~F=FF=FFD%=D2F=FF=FF