#26741 [Opn->Csd]: Problem on Get Varchar Colunms from Oracle 9i

ID: 26741 User updated by: fernando at napl dot com dot br Reported By: fernando at napl dot com dot br -Status: Open +Status: Closed Bug Type: OCI8 related Operating System: Linux RedHat 8 PHP Version: 4.3.4 New Comment: I am have Solved the Problem Compiling the php but ALL ORACLE ENV VARIABLES SETUP TO ROOT!! thanx for suppport! Fernando N. Previous Comments: ------------------------------------------------------------------------ [2003-12-29 09:28:35] 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 /> ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=26741&edit=1