php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
 [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: Sat Dec 21 14:01:32 2024 UTC