Create local temporary table in procedure

[#1]

Hi folks,

I have a procedure (I wrote in the procedure editor in Project Explorer).  In the procedure I'm trying to create a local temporary column table however when I attempt to activate the procedure I get error;

feature not supported: DDL is not supported in the READ ONLY procedure

In the past when I created a procedure via old method (via CONTENT/NEW PROCEDURE) I had the option of choosing READ or READ/WRITE.  I'm not seeing this option in the new procedure editor.  Also I noticed a second tab next to SQLScript tab called LOCAL TABLE TYPES.  I can't seem to place my create local temporary table there either.

I've read in other posts that this is possible... what do I need to do in order to be able to create and update this temp table?

Thanks,

-Patrick

[vivekbhoj]

Hi Patric,

I guess you are using HANA SPS07

In SPS07, the Local Temporary table concept is gone and we don't get tab for Local Table Type

Even the procedure extension has been changed to .hdbprocedure

We have to create hdbdd file to define global table types and then we can use these table types in our procedure

Check the below webcast for changes in HANA SPS07 SQLScript:

SAP HANA SPS 7 Call 2 SQLScript

Regards,

Vivek

[lbreddemann]

Hi Vivek,

as you see in my example above, the local temp. tables are not gone at all.

Not sure where you found the dis-support notice on local temp. tables...

- Lars

[vivekbhoj]

It is my mistake Lars

I mistook Local Table Type as Local Temporary Table

We can't define Local Table Types in hdbprocedure

Creating Temporary Table works for me when I create a Procedure in SQL Console but While trying to create Temporary local table in Project Explorer  as hdbprocedure, it gives me same error as Patrick

Regards,

Vivek