SAP Knowledge Base Article - Preview

2507907 - Error 277 when using 'enable select into in tran' - SAP ASE


  • 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.



SAP Adaptive Server Enterprise (ASE) 16.0


SAP Adaptive Server Enterprise 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,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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.