Skip to Content
0
Former Member
Nov 05, 2013 at 05:42 PM

Create HANA Procedure from ABAP

39 Views

Hi:

I am trying to create a HANA procedure from ABAP using this:

lo_sql = cl_sql_connection=>get_connection( hanasovantazz )->create_statement( ).

DATA lo_resultset TYPE REF TO cl_sql_result_set.

lo_sql->execute_query( 'drop procedure SAPFRA.TEST; create procedure SAPFRA.TEST() as begin select * from SAPFRA."PDM"; end; ' ).

I had the error:

sql syntax error: incorrect syntax near ";": line 1 col 23 (at pos 23)

I also tried execute_ddl with the same result.

Is mandatory to do it on the ABAP side, regarding the context of the problem.

Thanks!