php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #22724 OCIParse
Submitted: 2003-03-15 03:51 UTC Modified: 2003-04-28 04:34 UTC
From: admin at iut-info dot ens dot univ-reims dot fr Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.3.2RC1 OS: HP-UX 11.11
Private report: No CVE-ID: None
View Developer Edit
 [2003-03-15 03:51 UTC] admin at iut-info dot ens dot univ-reims dot fr 
----- CONFIGURE ------
./configure                             \
        --with-oci8                     \
        --with-apache=../apache_1.3.27  \
        --with-gd                       \
        --with-pdflib=/opt/pdflib       \
        --with-jpeg-dir                 \
        --with-png-dir                  \
        --with-tiff-dir                 \
        --with-zlib                     \
        --with-bz2                      \
        --enable-sigchild               \
        --with-mysql=/opt/mysql4        \
        --with-pgsql=/opt/pgsql         \
        --with-tsrm-pthreads            \
        --with-dom                      \
        --enable-ftp                    \
        --enable-sockets
----- testoci8.php ----------------------------------
<HTML><HEAD><TITLE>Test de connexion PHP - Oracle 8i</TITLE></HEAD>
<BODY>
<PRE><?php

putenv("ORACLE_HOME=/oracle/app/oracle/product/8.1.7");

$conn = OCILogon("collet", "pass", "bd8");
if ($conn ) {
        echo "OCILogon Ok\n";
        echo "Server Version: " . OCIServerVersion($conn) . "\n";

        $st=OCIParse($conn, "SELECT * FROM essai");
        if (OCIExecute($st))
                {
                $nrows = OCIFetchStatement($st,$results);
                print "<BR>$nrows Records Selected<BR>\n";
                }


        OCILogOff($conn);
        }
else    echo " OCILogon ERREUR\n";
?>
</PRE></BODY></HTML>
---- Result with PHP-4.3.0 -------
OCILogon Ok
Server Version: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production

2 Records Selected
---- Result with PHP-4.3.2 -----
OCILogon Ok
Server Version: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production


Warning:  ociparse() [function.ociparse]: OCIParse: ORA-00001: unique constraint (%s.%s) violated
 in /home/prof/collet/public_html/testoci8.php on line 12



Warning:  ociexecute(): supplied argument is not a valid OCI8-Statement resource in /home/prof/collet/public_html/testoci8.php on line 13
------------------
Cordialy.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-03-26 05:50 UTC] maxim@php.net 
Thank you for this bug report. To properly diagnose the problem, we
need a backtrace to see what is happening behind the scenes. To
find out how to generate a backtrace, please read
http://bugs.php.net/bugs-generating-backtrace.php

Once you have generated a backtrace, please submit it to this bug
report and change the status back to "Open". Thank you for helping
us make PHP better.

can you try to do the same test with the code that has OCIInternalDebug(1); function on top. Please post the output here.
 [2003-03-31 01:56 UTC] sniper@php.net 
No feedback was provided. The bug is being suspended because
we assume that you are no longer experiencing the problem.
If this is not the case and you are able to provide the
information that was requested earlier, please do so and
change the status of the bug back to "Open". Thank you.
 [2003-03-31 03:04 UTC] admin at iut-info dot ens dot univ-reims dot fr 
No backtrace because no crash.
With OCIInternalDebug(1);

The first time the page is called (just after apache start)
the result is ok. Here is the output :
----------------------------------------------
OCIDebug: _oci_open_server new conn=0 dname=bd8

OCIDebug: _oci_open_session new sess=3 user=collet

OCIDebug: oci_do_connect: id=4

OCILogon Ok
Server Version: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production
OCIDebug: oci_parse "SELECT * FROM essai" id=5 conn=4


2 Records Selected

OCIDebug: START php_rshutdown_oci
OCIDebug: END php_rshutdown_oci
OCIDebug: START _oci_stmt_list_dtor: id=5 last_query="SELECT * FROM essai"
OCIDebug: START _oci_column_hash_dtor: REF
OCIDebug: END _oci_column_hash_dtor: REF
OCIDebug: START _oci_column_hash_dtor: LIB
OCIDebug: END _oci_column_hash_dtor: LIB
OCIDebug: START _oci_conn_list_dtor: id=4
OCIDebug: nothing to do..
OCIDebug: END _oci_conn_list_dtor: id=4
OCIDebug: END _oci_stmt_list_dtor: id=5
OCIDebug: START _oci_close_session: logging-off sess=3
OCIDebug: START _oci_close_server: detaching conn=2 dbname=bd8
----------------------------------------------
And the page still works for a while..
Here is the output of the error :
----------------------------------------------
OCIDebug: _oci_open_server new conn=0 dname=bd8

OCIDebug: _oci_open_session new sess=3 user=collet

OCIDebug: oci_do_connect: id=4

OCILogon Ok
Server Version: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
JServer Release 8.1.7.0.0 - Production


Warning:  ociparse() [function.ociparse]: OCIParse: ORA-00001: unique constraint (%s.%s) violated
 in /home/prof/collet/public_html/testoci8.php on line 13



Warning:  ociexecute(): supplied argument is not a valid OCI8-Statement resource in /home/prof/collet/public_html/testoci8.php on line 14

OCIDebug: START php_rshutdown_oci
OCIDebug: END php_rshutdown_oci
OCIDebug: START _oci_conn_list_dtor: id=4
OCIDebug: nothing to do..
OCIDebug: END _oci_conn_list_dtor: id=4
OCIDebug: START _oci_close_session: logging-off sess=3
OCIDebug: START _oci_close_server: detaching conn=2 dbname=bd8
----------------------------------------------
It's very strange in fact.
When the error occurs one time, then
it's happen each time the page is call.

Cordially.
P.S. : sorry for the feedback time... (some holidays)
 [2003-04-23 04:57 UTC] sniper@php.net 
Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip
 [2003-04-28 04:23 UTC] admin at iut-info dot ens dot univ-reims dot fr 
Test with php4-STABLE-200304280730

It seems there is no more problem.

Cordially.
 [2003-04-28 04:34 UTC] edink@php.net 
User reports that the problem is fixed.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Fri May 09 05:01:27 2025 UTC