native and open sql - oracle

[Former Member]

hi all,

<dynamic > = SELECT matnr FROM mara .

EXEC SQL.

OPEN c1 FOR <dynamic >ENDEXEC.

ENDEXEC.

can i use dynamic native sql in open sql-oracle .

cheers

senthil

[Former Member]

hi all,

<dynamic > = SELECT matnr FROM mara .

EXEC SQL.

OPEN c1 FOR <dynamic >ENDEXEC.

ENDEXEC.

can i use dynamic native sql in open sql-oracle .

cheers

senthil

[ulrich_koch]

EXEC SQL doesn't allow for dynamic constructs. In order to get native SQL features dynamically you can use the JDBC-like classes CL_SQL_STATEMENT, CL_SQL_CONNECTION, and so on.

Best regards

Ulrich

[Former Member]

Thanks problem resolved.