every time i try to execute a select-query that would return more than one records i get the error-message:
"Warning: OCIStmtExecute: Error while trying to retrieve text for error ORA-03120". however, single-row-result queries are working (i.e. "select count(*) from <table>").
i read some postings where people get the same error-no while trying to connect to the db, but connection is successful i my case.
where is the problem?

the script:

<?php

  OCIInternalDebug(1); 

  $db = OCILogon($login,$pass);

  $stmt = OCIParse($db,"select * from pkvk",OCI_DEFAULT);

  OCIExecute($stmt);

  ...

?>

the output:

OCIDebug: oci_open_server new conn=0 dname=
OCIDebug: oci_open_session new sess=2 user=info
OCIDebug: oci_do_connect: id=3
OCIDebug: oci_parse "select * from pkvk" id=4 conn=3

Warning: OCIStmtExecute: Error while trying to retrieve text for error ORA-03120 in /usr/local/apache/htdocs/oratest/ora2.php on line 9
OCIDebug: START php_rshutdown_oci
OCIDebug: END php_rshutdown_oci
OCIDebug: START oci_stmt_list_dtor: id=4 last_query="select * from pkvk"
OCIDebug: START oci_conn_list_dtor: id=3
OCIDebug: nothing to do..
OCIDebug: END oci_conn_list_dtor: id=3
OCIDebug: END oci_stmt_list_dtor: id=4
OCIDebug: START oci_close_session: logging-off sess=2
OCIDebug: START oci_close_server: detaching conn=1 dbname=

i use:

  • apache 1.3.26,

  • php 4.2.1 with oci8 support,

  • Oracle 9.2.0.1 Client Software,

  • Oracle 8.0.5.1 DB-Server

    5 months later

    This problem sounds similar !

    If I try to execute an SQL statement that just selects a number everything works.

    But if I try to select a varchar2 column, I get an error.

    I think the error structure has changed in 9i. The error code reported seems to be some sort of sequence number as it justs keeps on getting bigger.

    My environment is AIX 5.1, Oracle 9.2.0.1.0, PHP 4.3.0, Apache 2.0.35, Borland AppServer 5.1

      Write a Reply...