SAP Knowledge Base Article - Preview

2408269 - SQL 259 invalid table name when selecting from local temporary table in procedure

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.