I'm evaluating HANA trial version with HANA Studio Version: 1.0.48.
we can't create procedures that uses i.e. dynamic SQL like EXEC in a project
Thats a limitation build into HANA
I had to switch to catalog and define a procedure directly in my schema
This works and I got my READ WRITE procedure, BUT now I have no possibility to DEBUG my source
because this seems only possible under projects explorer - and I'm trapped here
This is a little bit frustrating since I'm used to debug such procedures under ORACLE database
with SQL developer i.e.
For development this is a major backdrop: How you want to handle DDL/DML statements inside
procedures by using dynamic SQL i.e. for automating partition handling and NOT able to debug it in advance? 😠
Please can someone give an input?