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 begin-sql and end-sql block used by a delete statement. The solution was to move the commit; to its own begin-sql ... 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.


Revision #1
Created Sat, Aug 17, 2019 11:41 PM by PeopleSoft Wiki
Updated Sat, Aug 17, 2019 11:42 PM by PeopleSoft Wiki