cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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

Accepted Solutions (0)

Answers (0)