php – ORA-24374:在获取或执行和获取之前定义未完成
发布时间:2020-12-13 22:26:04 所属栏目:PHP教程 来源:网络整理
导读:这种if语句有效吗? if($result1 = oci_fetch_array($oms_query2) != null){} 它返回错误: Warning: oci_fetch_array() [function.oci-fetch-array]: ORA-24374: define not done before fetch or execute and fetch 这是代码片段: $oms_query = oci_parse
这种if语句有效吗?
if($result1 = oci_fetch_array($oms_query2) != null){} 它返回错误:
这是代码片段: $oms_query = oci_parse($conn_oms,"select * from R_VALIDATION order by query_id"); oci_execute($oms_query); while($row = oci_fetch_assoc($oms_query)) { extract($row); If ($ACTIVE=='Y') { $TOTAL++; $result = array(); $FIELD=explode(';',$FIELDS); $FIELD_COUNT=count($FIELD); $_SESSION[ 'field' ] = $FIELD; $_SESSION[ 'field_count' ] = $FIELD_COUNT; $testing = 0; $oms_query2 = oci_parse($conn_oms,$QUERY); oci_execute($oms_query2); if($result1 = oci_fetch_array($oms_query2) != null) { var_dump($result1); $IMPACTED++; if($FIELD[0]!=null) { $oms_query3 = oci_parse($conn_oms,$QUERY); oci_execute($oms_query3); while($result = oci_fetch_array($oms_query3)) $testing++; echo'<tr><td height="100%" bgcolor = "Linen" align="center" valign="middle"><b>'.$QUERY_ID.'</b></td><td bgcolor = "Linen"><b>'.$QUERY_NAME.'</b></td><td bgcolor = "Linen"><b>'.$QUERY_TYPE.'</b></td> <td bgcolor = "Linen" align="center" valign="middle"><b>'.$testing.'</b></td></tr>'; } oci_free_statement($oms_query2); } } } 解决方法
至少在这段代码中你没有设置’$QUERY’变量,因此无法解析它,因此无法执行提取.
(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |