2507907 - Error 277 when using 'enable select into in tran' - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

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


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 16.0

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