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 ?