Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

native and open sql - oracle

Former Member

‎2004 Oct 25 1:14 PM

0 Likes
492

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

2 REPLIES 2
Read only

ulrich_koch
Explorer

‎2004 Nov 12 11:44 AM

0 Likes
446

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

Read only

Former Member

‎2011 Aug 16 6:33 AM

0 Likes
446

Thanks problem resolved.