ID: 24740 Updated by: [EMAIL PROTECTED] Reported By: rarteaga at icaro dot com dot ec -Status: Open +Status: Bogus Bug Type: OCI8 related Operating System: Linux RH9 and RH7.3 PHP Version: 4.3.3RC2-dev New Comment:
The environment variables has to be set in the shell prior to starting your webserver. Setting them in a script has no effect whatsoever. Previous Comments: ------------------------------------------------------------------------ [2003-08-20 14:47:01] rarteaga at icaro dot com dot ec Yes I've setted the relevant configuration variables. Among others I have the most important one: putenv("ORACLE_HOME=/opt/oracle/product/9.2.0"); I've tryed others about language, TNS NAMES, etc... None of them solved the problem, As I said is working fine until you try to make a SELECT in witch you have to get information from a varchar2() fields on the table... I've stopped using OCI8 extension for the moment, instead I'm using the oracle extension (ora_Logon, ora_Execute, etc.) and its working fine, I solved my problem so far. However OCI8 has a lot more special functions I'm interested on using... Best Regards... ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/24740 -- Edit this bug report at http://bugs.php.net/?id=24740&edit=1