Skip to Content
0
Former Member
May 04, 2013 at 02:05 PM

HANA Studio and READ ONLY procedures / debug catalog-based procedures

445 Views

Dear experts,

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

Problem:

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?