Symptom
- With configuration "enable select into in tran" set to ON
- Executing a stored procedure which creates temporary tables in an user transaction return the following error:
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.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0
Product
Keywords
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,CR319075 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview