php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #26741 Problem on Get Varchar Colunms from Oracle 9i
Submitted: 2003-12-29 09:28 UTC Modified: 2003-12-29 14:33 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:1 (100.0%)
Same OS:1 (100.0%)
From: fernando at napl dot com dot br Assigned:
Status: Closed Package: OCI8 related
PHP Version: 4.3.4 OS: Linux RedHat 8
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: fernando at napl dot com dot br
New email:
PHP Version: OS:

 

 [2003-12-29 09:28 UTC] fernando at napl dot com dot br 
Description:
------------
I have the Problem on fetch Columns Varchar os Char from oracle..
I Have changed the Group of Apache on httpd.conf to oracle user..

All ENV Variables on oracle user already ok..

On SQlplus this machi I not have problems...

Thanks for any help...



Reproduce code:
---------------
 while ($arr_my_emp = mysql_fetch_row($exec_my_emp)) {
        $sql_ora_emp="SELECT CD_EMP,NM_EMP FROM          EMPS WHERE CD_EMP = $arr_my_emp[0]";            
   	$stm_ora_emp=ociparse($conn_oracle,$sql_ora_emp);
        $exec_ora_emp=ociexecute($stm_ora_emp);
        ocifetchinto($stm_ora_emp,$arr_ora_emp,OCI_NUM);
        echo "<option value=\"$arr_ora_emp[0]\">$arr_ora_emp[0]</option>";
    }      
?>

Expected result:
----------------
One Combo box whit option from table EMPS

Actual result:
--------------
Warning</b>:  ociexecute(): OCIStmtExecute: ORA-03106: fatal two-task communication protocol error
 in <b>/www/htdocs/vw/main.php</b> on line <b>131</b><br />
<br />
<b>Warning</b>:  ocifetchinto(): OCIFetchInto: ORA-24374: define not done before fetch or execute and fetch
 in <b>/www/htdocs/vw/main.php</b> on line <b>132</b><br />
<option value=""></option><br />

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-12-29 14:33 UTC] fernando at napl dot com dot br 
I am have Solved the Problem Compiling the php but ALL ORACLE ENV VARIABLES SETUP TO ROOT!!

thanx for suppport!

Fernando N.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sun Dec 22 01:01:30 2024 UTC