Troubleshoot fix resolve ORA-01453: SET TRANSACTION must be first statement of transaction

Error Description: self-evident
Fix for this error: commit (or rollback) transaction, and re-execute