Error Code 5528
(SQR 5528) ORACLE OCIStmtExecute error 933 in cursor 11: ORA-00933: SQL command not properly ended
I caused this error by placing a single commit; statement within the same
end-sql block used by a delete statement. The solution was to move the commit; to its own
end-sql block like this:
#ifdef ORACLE begin-sql commit; end-sql #endif
There are actually a number of reasons why this error may occur and they are generally due to Oracle not being able to interpret the SQL passed by SQR. The error tells you which cursor is in error. If you can't find what part of your code is causing the issue, start with an SQR SQL trace then use the output file to find the cursor number that is causing you grief.