Hi,
I am using Oracle to store sessions and i occasionally get an ORA-933 error when the session expires (detailed below
Error generated:
"Warning: OCIStmtExecute: ORA-00933: SQL command not properly ended in <path>/Session.class on line 232"
Code (line 232 documented):
function EXPIRE($sessid) {
$query = "DELETE FROM session_expires WHERE
timestamp < " . time() . " and
sessid=$sessid";
$stmt = OCIParse($this->conn, $query);
232:OCIExecute($stmt,OCI_COMMIT_ON_SUCCESS);
OCIFreeStatement($stmt);
}
I thought it was because the SQL does not end in a semi-colon, although, neither do any of the other hundred or so queries and they seem fine.
Any idea's, please?
Shaun
I am using Oracle to store sessions and i occasionally get an ORA-933 error when the session expires (detailed below
Error generated:
"Warning: OCIStmtExecute: ORA-00933: SQL command not properly ended in <path>/Session.class on line 232"
Code (line 232 documented):
function EXPIRE($sessid) {
$query = "DELETE FROM session_expires WHERE
timestamp < " . time() . " and
sessid=$sessid";
$stmt = OCIParse($this->conn, $query);
232:OCIExecute($stmt,OCI_COMMIT_ON_SUCCESS);
OCIFreeStatement($stmt);
}
I thought it was because the SQL does not end in a semi-colon, although, neither do any of the other hundred or so queries and they seem fine.
Any idea's, please?
Shaun