Skip to Content
Jun 21, 2016 at 02:51 PM

Delete in HANA Stored procedure temporary table


Hi All,

I have a stored procedure with logic like as follows. I am getting an error like "

sql syntax error: incorrect syntax near ":lt_mara": line 201 col 2"

lt_mara = select * from MARA where matnr like 'PART%' ;

delete from :lt_mara where matnr = 'PART-AB';

I am trying to delete a particular set of records from temporary table based on condition.

Is this possible in SAP HANA ? will it work only for query on DATABASE TABLE rather than temporary table ?

I agree there is an alternate way to select from LT_MARA where MATNR <> PART-AB .

I want to know why the delete does not work ? Is it because the lt_mara was created at runtime, the compiler giving error for delete statements ?