NYCPHP Meetup

NYPHP.org

[nycphp-talk] Oracle function order

Nathan Lavertue nd at lavertue.com
Mon Aug 30 16:23:47 EDT 2004


Is there an order of which you should follow when giving Oracle
functions?  Well, clearly you'd want to login and create a
query before supplying a command, but, beyond that.

I've got some PHP 5.x scripts running... and, it's odd, the
return I receive. I get both an Oracle database error, but yet
I get the query results.

It's quite confusing....

Here is the entire echo listing...
----
Warning: oci_fetch() [function.oci-fetch]: OCIFetch: ORA-01002:
fetch out of sequence  in
/Users/nlavertue/sample_return_oracle.php on line 28
data_entries=2
&DATE_TX_0=8-2004
&DATE_TX_1=9-2004
&T1_FTE_0=6000
&T1_FTE_1=0
&T2_FTE_0=7500
&T2_FTE_1=0
&ACT_FTE_0=7500
&ACT_FTE_1=6750

Warning: Unknown: _oci_close_session OCIHandleAlloc
OCI_HTYPE_SVCCTX: OCI_INVALID_HANDLE in Unknown on line 0

Warning: Unknown: _oci_close_session: OCIAttrSet
OCI_ATTR_SERVER: OCI_INVALID_HANDLE in Unknown on line 0

Warning: Unknown: _oci_close_session: OCIAttrSet
OCI_ATTR_SESSION: OCI_INVALID_HANDLE in Unknown on line 0

Warning: Unknown: _oci_close_session: OCISessionEnd:
OCI_INVALID_HANDLE in Unknown on line 0
----
... I don't even know where to start really. I want to get past
the Oracle errors, because I need to debug the rest of the PHP
code, but it seems like they will never go away.

Thanks.
..................
nd lavertue // .flash.soldier/pixel.terrorist.
...................
lavertue.com // mutemuse.com
...................





More information about the talk mailing list