ID: 24740 Updated by: [EMAIL PROTECTED] Reported By: rarteaga at icaro dot com dot ec -Status: Feedback +Status: No Feedback Bug Type: OCI8 related Operating System: Linux RH9 and RH7.3 PHP Version: 4.3.3RC2-dev 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-08-13 21:46:38] [EMAIL PROTECTED] Have you set the relevant environment variables in the shell before you run the script? (setting them inside the script does not work) ------------------------------------------------------------------------ [2003-07-22 11:59:20] rarteaga at icaro dot com dot ec Still not working, I downloaded and run the script with the CVS snapshot: http://snaps.php.net/php4-STABLE-latest.tar.gz The backtrace I get: 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 ------------------------------------------------------------------------ [2003-07-22 10:33:12] [EMAIL PROTECTED] 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 AFAIK, this is fixed already. ------------------------------------------------------------------------ [2003-07-21 11:58:21] rarteaga at icaro dot com dot ec I'm sorry I made a mistake on the line OCIDefineByName($parse,"ENAME",$job); The correct value must be JOB, it will be like this: OCIDefineByName($parse,"JOB",$job); Still doesn't work.. Regards ------------------------------------------------------------------------ [2003-07-21 11:54:58] rarteaga at icaro dot com dot ec Description: ------------ Hi, I've installed Linux RH 9.0 and Oracle 9i, I'm trying to access the database from a php script, I make de connection and make a simple select like this: "SELECT EMPNO from EMP" And I get the information just fine with the oci functions (OCILogon, OCIParse, OCIExecute, etc...). Now I get a segmentation fault when I try to retrieve information of fields that are string or characteres, something like this: "SELECT JOB from EMP" The script crashes and dies saying "segmentation fault" I'm connecting to the database as user "SCOTT" and getting information from table EMP. I can connect from an aplication I've developed in VB60 from a remote aplication server I have... but PHP is crashing... Best Regards Reproduce code: --------------- #!/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,"ENAME",$job); OCIExecute($parse,OCI_DEFAULT); echo "\nRecuperacion de datos\n"; while (OCIFetchinto ($parse, $row, OCI_ASSOC)) { echo $job; echo "\n"; } } ?> Expected result: ---------------- I expect to see de job titles.. Actual result: -------------- [EMAIL PROTECTED] htdocs]# ./oracle.php Connected! Segmentation fault ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=24740&edit=1
