ID: 24740
Updated by: [EMAIL PROTECTED]
Reported By: rarteaga at icaro dot com dot ec
-Status: Open
+Status: Feedback
Bug Type: OCI8 related
Operating System: Linux RH9 and RH7.3
PHP Version: 4.3.3RC2-dev
New Comment:
What was the configure line used to configure PHP?
Previous Comments:
------------------------------------------------------------------------
[2003-08-20 18:09:18] rarteaga at icaro dot com dot ec
As you can see in the detail of this bug report, I'm not running the
script from a webserver, that's why I put:
#!/usr/bin/php -q
to run it from the console like this:
./oracle.php
I get the result in the standar output.
Setting the relevant configuration variables in the script do work, if
I do not put this line for example:
putenv("ORACLE_HOME=/opt/oracle/product/9.2.0");
The script will simple tell me that ORACLE is not present and so on.
I understand that once the script works fine, I'll have to put the
correct env. variables so Apache knows ORACLE its present, mean while
putenv works just fine...
------------------------------------------------------------------------
[2003-08-20 17:49:21] [EMAIL PROTECTED]
The environment variables has to be set in the shell prior to starting
your webserver. Setting them in a script has no effect whatsoever.
------------------------------------------------------------------------
[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
------------------------------------------------------------------------
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
