SAP OO OBS EXEC SQL 1 documentation, setup help and example usage

INCLUDE
ARTICLE

Subroutine Calls Not Allowed in EXEC SQL

Using the PERFORMING addition in the EXEC SQL statement to use a subroutine to process data line by line that you have read using Native SQL is not allowed in ABAP Objects. The EXIT FROM SQL statement, previously used within such subroutines, is also forbidden.

In ABAP Objects, the following syntax causes an error message:

EXEC SQL PERFORMING form.
select ... into :wa from dbtab where ...
ENDEXEC.

FORM form.
...
EXIT FROM SQL.
...
ENDFORM.

Correct syntax:

EXEC SQL.
open c1 for
select ... from dbtab where ...
ENDEXEC.

DO.
EXEC SQL.
fetch next c1 into :wa
ENDEXEC.
IF sy-subrc 0.
EXIT.
ENDIF.
...
ENDDO.

EXEC SQL.
close c1
ENDEXEC.

Reason:

You should not call subroutines of the main program in local classes and you cannot call them in them from global classes. The called subroutine has no interface, working instead with the global data of the main program . The EXIT FROM SQL statement ends the SQL processing without reference to the actual SQL statement.