查询语句中可否用php变量?????
查询语句: $temp_table_name=$e_lurudanwei."_".$sub_name[$i][$k];
$query="select ".$sub_name[$i][$k]." from ".$temp_table_name;
调用函数出错:
$num_of_sub_kind[$i]=num_of_subs_getting($query);
function num_of_subs_getting($query)
{
$connection=ora_logon("feng@bnyypkxt","feng");
$cursor= ora_open($connection);
ora_commitoff($connection);
if (!(ora_parse($cursor,$query) or die))
{ return "-1";
exit;}
if (! (ora_exec($cursor)))
{ return "0";
exit;
}
$result=array();
while(ora_fetch_into($cursor,$result))
{
$data.=$result[$i]."!#$%";
}
ora_close($cursor);
ora_logoff($connection);
return $data;
}
错误:
Warning: Ora_Parse failed (ORA-00911: 无效字符 -- while processing OCI function OPARSE) in d:\newfile\bnyypkxt20030713\web\cgi\luru_main.php on line 559