Symptom
- After upgrade to SAP HANA 1.0 SP12, procedures using local temporary tables fail at the SELECT statement with SQL error 259 invalid table name.
- Error may appear as: invalid table name: Could not find table/view <#Temporary Table Name> in schema .
- The error typically points to the SELECT statement within the procedure.
Read more...
Environment
- SAP HANA 1.0 SP12 (SPS12)
- SAP HANA Database
Product
SAP HANA 1.0, platform edition
Keywords
SPS12, SQL 259, invalid table name, local temporary table, #temp, procedure, table function, default schema, schema resolution, schema-qualified name, post-upgrade error, temporary table scope, unqualified reference, HANA revision 122.06, SELECT statement , KBA , HAN-DB , SAP HANA Database , Problem
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.
SAP Knowledge Base Article - Preview