- With configuration "enable select into in tran" set to ON
- Executing a stored procedure which creates temporary tables in a transaction will return error 277:
Msg 277, Level 16, State 1:
Server 'ASE16', Procedure 'p', Line 4:
There was a transaction active when exiting the stored procedure 'p'.
The temporary table '#t' was dropped in this transaction either explicitly or implicitly.
This transaction has been aborted to prevent database corruption.
Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing.
Previous count = 1, Current count = 0.
SAP Adaptive Server Enterprise (ASE) 16.0
CR 809261, CR809261, stored proc executed within a transaction, stored procedure executed within a tran, temp table within tran, temporary table in a transaction, sp_setrepproc, temp tables , 2762 . 277 , message 277 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.