on 04-11-2017 5:07 AM
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
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.