PHP 4.0 Bug #5171: Impossible to use OCI Cursors
| From: | alex dot scotti at tiscalinet dot it | 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