2562119 - Update cursor fails with error 594 with "optimize temp table resolution" on - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2562119 - Update cursor fails with error 594 with "optimize temp table resolution" on - SAP ASE

Symptom

  • Update cursor fails with error 594
  • When "optimize temp table resolution" is ON (1)
  • And a #temp table is dropped and recreated outside of the procedure with the cursor:

Msg 594, Level 16, State 1:
Server 'ASE', Procedure 'proc_name', Line #:
The UPDATE WHERE CURRENT OF to the cursor 'cursor_name' failed because column 'column_name' being updated was not specified in the SELECT list.


Read more...

Environment

SAP Adaptive Server Enterprise 15.7 & 16.0

Product

SAP Adaptive Server Enterprise 15.7

Keywords

594 , "message 594" , "msg 594" , "error 594" , 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.