如用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 7Warning: ocifetch(): OCIFetch: ORA-24338: 未执行语句句柄 in /usr/local/apache/htdocs/select.php on line 11
<?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 7Warning: ocifetch(): OCIFetch: ORA-24338: 未执行语句句柄 in /usr/local/apache/htdocs/select.php on line 11
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货