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.
SAP Adaptive Server Enterprise 15.7 & 16.0
594 , "message 594" , "msg 594" , "error 594" , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this pageThis 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.