PHP 4.0 Bug #5171: Impossible to use OCI Cursors

From: Date: Wed, 21 Jun 2000 14:23:27 +0000
Subject: PHP 4.0 Bug #5171: Impossible to use OCI Cursors
Groups: php.dev 
Request: Send a blank email to php-dev+get-22073@lists.php.net to get a copy of this message
From: alex.scotti@tiscalinet.it Operating system: Windows 2000 PHP version: 4.0.0 Release PHP Bug Type: Oracle related Bug description: Impossible to use OCI Cursors 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

« previous php.dev (#22073) next »