新人求助!oci_execute(): ORA-00933: SQL command not properly ended
做一个简单的php系统,要求连接到数据库,然后调取相应信息,连接部分代码如下:
switch($_GET["Action"])
{
case "Update":
$conn = oci_connect("s12345","1234567","sss");
$query="SELECT * FROM PROPERTY WHERE PROPERTY_ID=".$_GET["propertyno"];
$stmt = oci_parse($conn,$query);
oci_execute($stmt);
$row = oci_fetch_array ($stmt);
?>
然后运行的时候,网页报错:
oci_execute(): ORA-00933: SQL command not properly ended
请问我的sql代码哪里有问题呢? 谢谢!