Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers