Entry

When I execute an OCIExecute statement I get an "invalid statement" error, but I'm not sure why?

Nov 7th, 2001 00:46
Sally Greenaway, Tracey Vernon,

Whenever I have received this error message it has been due to the fact 
that the statement that is being executed hasn't successfully been 
parsed by Oracle.
This is usually because of a syntax error in the original Select 
statment. e.g.
$select="Select firstname, lastname from addresses where MAX(age)";
$select_parse=ociparse($dbconn, $select);
ociexecute ($select_parse);
These statements will result in an "Invalid Statement Error" because 
the MAX(age) condition is invalid in Oracle, group functions cannot be 
performed in the WHERE clause of a statement.