[SOLVED] SQL command not properly ended

[rbragg]

The following gives me:

 

HP Warning:  ociexecute(): OCIStmtExecute: ORA-00933: SQL command not properly ended

 

<?php
$queryLastCall = "
SELECT call_num
FROM schema.table
ORDER by call_num DESC
LIMIT 1
"; 
$lastCall = ociparse($connect, $queryLastCall);
ociexecute($lastCall);

$callNum = ociresult($lastCall, "CALL_NUM");
?>

 

It may be of importance to note that I have many queries on this page and this is the only one where I do ORDER and LIMIT clauses. Thanks in advance!

[HuggieBear]

Oracle doesn't have the concept of a LIMIT clause, so your syntax is incorrect.

 

Regards

Huggie