SAP Knowledge Base Article - Preview

2731839 - Incorrect syntax error on FETCH CURSOR when 'procedure deferred compilation' is enabled - SAP ASE

Symptom

If 'procedure deferred compilation' is enabled as following,

1> sp_configure 'procedure deferred compilation',1
2> go

FETCH CURSOR will report syntax error like

Msg 102, Level 15, State 181:
Server '<servername>', Line 7:
Incorrect syntax near '='.

The issue doesn't exist on ASE16.0 SP02 patch levels or earlier.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL04

Product

SAP Adaptive Server Enterprise 16.0

Keywords

procedure deferred compilation, Msg 102, FETCH CURSOR, CR#817681, CR 817681 , 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.