topic Re: abap sql convert to native sql fuction in Application Development and Automation Discussions

abap sql convert to native sql fuction

Former Member — Fri, 05 Feb 2010 01:47:27 GMT

hi expert!

exist a function can do follow things:

convert selection-screen's select-options which user key in

to oracle where condition expression

or exist one function can convert abap sql to oracle sql

thank you very much

Former Member — Wed, 10 Feb 2010 11:13:20 GMT

example:

EXEC SQL.

CONNECT TO :'DATA BASE NAME'

ENDEXEC.

IF sy-subrc EQ 0 .

TRY.

EXEC SQL .

SELECT COUNT(*) FROM <TABLE NAME>

INTO :recount

WHERE code = :itab-<FIELD>

ENDEXEC .

CATCH cx_sy_native_sql_error INTO exc_ref.

error_text = exc_ref->get_text( ).

MESSAGE error_text TYPE 'I'.

ENDTRY.