我用的版本是php5.2.3,测试连接显示连接到oracle数据库成功,紧接着我就想查询各视图,但是什么都不显示怎么回事啊;
<?
$conn=oci_connect("XXX","xxxx","(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = policext)
)
)");
if($conn)
{
echo "连接成功!";
exit;
}
else
{ echo "连接失败!";
}
$sql="select * from vw_led_duty ";
$stmt=oci_parse($conn,$sql);
oci_execute($stmt);
$result=oci_fetch_assoc($stmt);
print_r($result);
?>
望高手指点下;vw_led_duty 是个视图在plsql中是正常的可以查询到数据;
<?
$conn=oci_connect("XXX","xxxx","(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = policext)
)
)");
if($conn)
{
echo "连接成功!";
exit;
}
else
{ echo "连接失败!";
}
$sql="select * from vw_led_duty ";
$stmt=oci_parse($conn,$sql);
oci_execute($stmt);
$result=oci_fetch_assoc($stmt);
print_r($result);
?>
望高手指点下;vw_led_duty 是个视图在plsql中是正常的可以查询到数据;
错误提示有没有打开
exit;exit了后面的代码还会执行么?