- ASE outputs error 225 the first time a table variable is used within a derived table in a statement while statement cache is on.
- ASE outputs error 11049 for subsequent executions of the statement while statement cache is on.
Msg 225, Level 16, State 1:
Cannot run query--referenced object (name NAME NOT RECOVERABLE) dropped during
Msg 11049, Level 16, State 3:
Server 'ASE', Line 3:
The definition of table variable '@tt' is missing. Make sure it is declared with
a table schema in the same batch before using it.
- SAP Adaptive Server Enterprise (ASE) version 16.0 SP02 and higher
- Table variable
- Derived table
- Statement Cache
Sybase, ASEServer, SAPASE, dataserver, table variable, derived table, statement cache , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , 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.