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 for Me (Login required).

Search for additional results

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