#22724 [Fbk->NoF]: OCIParse: ORA-00001

ID: 22724 Updated by: sniper@php.net Reported By: admin at iut-info dot ens dot univ-reims dot fr -Status: Feedback +Status: No Feedback Bug Type: OCI8 related Operating System: HP-UX 11.11 PHP Version: 4.3.2RC1 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [2003-03-26 05:50:26] 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-15 03:51:53] 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. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=22724&edit=1