求教oracle+php的问题

[wangyoucao1234]

初学php，遇到这么一个问题，请高手帮忙解决，程序如下:
<?php




$query="SELECT l_danwei_name,c_danwei_name,e_danwei_name";
$query.=" FROM feng.luru_danwei_info";

$connection=ora_logon("feng","feng","bnyy");
$cursor= ora_open($connection);
ora_parse($cursor,$query);

ora_exec($cursor);

while(ora_fetch($cursor))
{
$numcolms=ora_numcols($cursor);
for ($numcolm=0;$numcolm<$numcolms;$numcolm++)
{
$data=trim(ora_getcolumn($cursor,$numcolm));
echo "$data\t";
}
}

ora_close($cursor);
ora_logoff($connection);



?>

运行结果产生错误如下:
Warning: Ora_Parse failed (ORA-00942: 表或视图不存在 -- while processing OCI function OPARSE) in /usr/local/apache/htdocs/select.php on line 11

Warning: Ora_Exec failed (ORA-01003: 语句未进行语法分析 -- while processing OCI function OEXEC/OEXN) in /usr/local/apache/htdocs/select.php on line 13

Warning: No tuples available on this cursor in /usr/local/apache/htdocs/select.php on line 15
表已存在，数据库是oracle9i，操作系统是redhat8+php－4.3.4+apache_1.3.29

[wangyoucao1234]

如用oci函数:
<?php




$query="SELECT l_danwei_name,c_danwei_name,e_danwei_name";
$query.=" FROM feng.luru_danwei_info";

$connection=ocilogon("feng","feng","bnyy");
$cursor= ocinewcursor($connection);
ociparse($cursor,$query);

ociexecute($cursor);

while(ocifetch($cursor))
{
$numcolms=ocinumcols($cursor);
for ($numcolm=0;$numcolm<$numcolms;$numcolm++)
{
$data=trim(ocigetcolumn($cursor,$numcolm));
echo "$data\t";
}
}

ocifreecursor($cursor);
ocilogoff($connection);



?>
错误如下:
Warning: ociparse(): supplied resource is not a valid OCI8-Connection resource in /usr/local/apache/htdocs/select.php on line 7

Warning: ocifetch(): OCIFetch: ORA-24338: 未执行语句句柄 in /usr/local/apache/htdocs/select.php on line 11

[hjh1203]

加上oracle_home和oracle_sid