OCI Cursors do not work under W2K-IIS/Apache
| From: | Alessandro Scotti | Date: | Tue, 27 Jun 2000 10:17:33 +0000 |
| Subject: | OCI Cursors do not work under W2K-IIS/Apache | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-3304@lists.php.net to get a copy of this message | ||
Trying to pass cursors this happens:
Package description:
CREATE OR REPLACE PACKAGE NEST.META AS
TYPE REF_C IS REF CURSOR RETURN NEST.STRUTTURA%ROWTYPE;
PROCEDURE STRUTTURA_C(C IN OUT REF_C);
...........
CREATE OR REPLACE PACKAGE BODY NEST.META AS
PROCEDURE STRUTTURA_C(C IN OUT REF_C)
IS
BEGIN
OPEN C FOR SELECT * FROM NEST.STRUTTURA;
END STRUTTURA_C;
.............
Script:
<?
OCIInternalDebug(1);
$c=OCILogon($u, $p, 'utf8');
$curs=OCINewCursor($c);
$stmt=OCIParse($c, "BEGIN NEST.META.STRUTTURA_C(:CURS); END;");
OCIBindByName($stmt, ":CURS", $curs, -1, OCI_B_CURSOR);
OCIExecute($stmt);
OCIExecute($curs);
OCIFetch($curs);
?>
Output:
OCIDebug: _oci_open_server new conn=0 dname=utf8
OCIDebug: _oci_open_session new sess=2 user=nest
OCIDebug: oci_do_connect: id=3
OCIDebug: oci_parse "" id=4 conn=3
OCIDebug: oci_parse "BEGIN NEST.META.STRUTTURA_C(:CURS); END;" id=5 conn=3
Warning: OCIFetch: ORA-24374: define not done before fetch or execute and
fetch in
D:\WWW\nest\catalogo\varie\prove.php on line 9
OCIDebug: START php_rshutdown_oci
OCIDebug: END php_rshutdown_oci
OCIDebug: START _oci_stmt_list_dtor: id=5 last_query="BEGIN
NEST.META.STRUTTURA_C(:CURS); END;"
OCIDebug: _oci_bind_hash_dtor:
OCIDebug: END _oci_stmt_list_dtor: id=5
OCIDebug: START _oci_stmt_list_dtor: id=4 last_query=""
OCIDebug: END _oci_stmt_list_dtor: id=4
OCIDebug: START _oci_conn_list_dtor: id=3
OCIDebug: END _oci_conn_list_dtor: id=3
OCIDebug: _oci_close_session: logging-off sess=2
OCIDebug: START _oci_close_server: detaching conn=1 dbname=utf8