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.