ID: 24907
Updated by: [EMAIL PROTECTED]
Reported By: rarteaga at icaro dot com dot ec
-Status: Open
+Status: Bogus
Bug Type: OCI8 related
Operating System: Linux 7.3 9.0
PHP Version: 4.3.3RC2
New Comment:
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the existing bug instead.
Thank you for your interest in PHP.
....
Previous Comments:
------------------------------------------------------------------------
[2003-08-01 12:03:48] rarteaga at icaro dot com dot ec
Description:
------------
Hi,
Time ago I submitted a bug report about a problem with oracle 9i and RH
Linux 7.3 or 9.0 and PHP 4.3.3RC2.
here is the code I use:
#!/usr/bin/php -q
<?php
putenv("ORACLE_HOME=/opt/oracle/product/9.2.0");
$username = "SCOTT";
$passwd = "TIGER";
$db="icaro";
$conn = OCILogon($username,$passwd,$db);
if (!$conn) {
echo "Connection failed";
echo "Error Message: [" . OCIError($conn) . "]";
exit;
}
else {
echo "Connected!"."\n";
$parse = OCIParse($conn,"select JOB from EMP");
OCIDefineByName($parse,"JOB",$job);
OCIExecute($parse,OCI_DEFAULT);
echo "\nRecuperacion de datos\n";
while (OCIFetchinto ($parse, $row, OCI_ASSOC)) {
echo $job;
echo "\n";
}
}
?>
I have no problem with fields on the database that are numbers, but
when I try to select fields that are strings (varchars), a Segmentation
Fault appears...
I tryed the last CVS snapshot:
http://snaps.php.net/php4-STABLE-latest.tar.gz
but It didn't work, same error Segmentation Fault.
Here is the backtrace I get for this:
Starting program: /usr/bin/php oracle.php
[New Thread 1084011968 (LWP 12585)]
Content-type: text/html
X-Powered-By: PHP/4.3.3RC2-dev
Connected!
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1084011968 (LWP 12585)]
0x4207bfea in memcpy () from /lib/tls/libc.so.6
(gdb) bt
#0 0x4207bfea in memcpy () from /lib/tls/libc.so.6
#1 0x40406a13 in nioqrc () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#2 0x40538395 in ttcdrv () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#3 0x4040d1a8 in nioqwa () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#4 0x40261330 in upirtrc () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#5 0x4022393a in kpurcsc () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#6 0x401e6124 in kpuexecv8 () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#7 0x401e7cf7 in kpuexec () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#8 0x4024598f in OCIStmtExecute () from
/opt/oracle/product/9.2.0/lib/libclntsh.so.9.0
#9 0x08083efd in oci_execute (statement=0x822c014, func=0x817d0d6
"OCIExecute", mode=32)
at /usr/local/php4-STABLE-200307221530/ext/oci8/oci8.c:1491
#10 0x0808a1c0 in zif_ociexecute (ht=1, return_value=0x822bf94,
this_ptr=0x0, return_value_used=0)
at /usr/local/php4-STABLE-200307221530/ext/oci8/oci8.c:3972
#11 0x0816fbc7 in execute (op_array=0x81ff58c) at
/usr/local/php4-STABLE-200307221530/Zend/zend_execute.c:1616
#12 0x08160182 in zend_execute_scripts (type=8, retval=0x0,
file_count=3)
at /usr/local/php4-STABLE-200307221530/Zend/zend.c:885
#13 0x08130aec in php_execute_script (primary_file=0xbfffdc90) at
/usr/local/php4-STABLE-200307221530/main/main.c:1685
#14 0x08175ead in main (argc=2, argv=0xbfffdd34) at
/usr/local/php4-STABLE-200307221530/sapi/cgi/cgi_main.c:1542
#15 0x42015504 in __libc_start_main () from /lib/tls/libc.so.6
I hope you have came out with a patch for this
Thank you very much...
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24907&edit=1
