abap sql convert to native sql fuction

[Former Member]

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]

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.