ID: 24740
User updated by: rarteaga at icaro dot com dot ec
Reported By: rarteaga at icaro dot com dot ec
-Status: No Feedback
+Status: Open
Bug Type: OCI8 related
Operating System: Linux RH9 and RH7.3
PHP Version: 4.3.3RC2-dev
New Comment:
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...
Previous Comments:
------------------------------------------------------------------------
[2003-08-18 19:43:01] [EMAIL PROTECTED]
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.
------------------------------------------------------------------------
[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
