Skip to Content
0

warning msg "Use of Native sql" while migrating from Oracle to HANA

Apr 11, 2017 at 04:07 AM

68

avatar image
Former Member

I am transforming our oracle based ABAP code to HANA based code.So during this procedure I need to replace the native sql statement EXEC sql-ENDEXEC with some other HANA compatible statement because this statement is giving WARNINGS in code inspector. I can't find any kind of replacement statement of this native sql.

This is my code in ABAP

exec sql.         
 create or replace procedure 
       zsdbr001_execsql (sqlstmt in varchar2) as         
   begin                 
    execute immediate sqlstmt;           
   end;
endexec.

When I am checking this in code inspector its showing warning msgs.

"Use of native SQL"

If i use pseudo comment "#EC CI_EXECSQL , warning msgs are not coming when checking in code inspector.

exec "#EC CI_EXECSQL
    sql.
        *} REPLACE create or replace procedure 
            zsdbr001_execsql (sqlstmt in varchar2) as
        begin 
             execute immediate sqlstmt;
        end;
 endexec.

If i use above pseudo comment and migrate this to HANA , will this work in HANA DB?

So please help me to do this.

Thank in advance

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers