topic Re: native and open sql - oracle in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/native-and-open-sql-oracle/m-p/782677#M39368 <HTML><HEAD></HEAD><BODY><P>Thanks problem resolved.</P></BODY></HTML> Tue, 16 Aug 2011 05:33:02 GMT Former Member 2011-08-16T05:33:02Z native and open sql - oracle https://community.sap.com/t5/application-development-and-automation-discussions/native-and-open-sql-oracle/m-p/782675#M39366 <HTML><HEAD></HEAD><BODY><P>hi all,</P><P></P><P>&lt;dynamic &gt; = SELECT matnr FROM mara .</P><P></P><P>EXEC SQL.</P><P> OPEN c1 FOR &lt;dynamic &gt;ENDEXEC.</P><P>ENDEXEC.</P><P></P><P>can i use dynamic native sql in open sql-oracle .</P><P></P><P>cheers</P><P>senthil</P></BODY></HTML> Mon, 25 Oct 2004 12:14:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/native-and-open-sql-oracle/m-p/782675#M39366 Former Member 2004-10-25T12:14:52Z Re: native and open sql - oracle https://community.sap.com/t5/application-development-and-automation-discussions/native-and-open-sql-oracle/m-p/782676#M39367 <HTML><HEAD></HEAD><BODY><P>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.</P><P>Best regards</P><P> Ulrich</P></BODY></HTML> Fri, 12 Nov 2004 11:44:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/native-and-open-sql-oracle/m-p/782676#M39367 ulrich_koch 2004-11-12T11:44:59Z Re: native and open sql - oracle https://community.sap.com/t5/application-development-and-automation-discussions/native-and-open-sql-oracle/m-p/782677#M39368 <HTML><HEAD></HEAD><BODY><P>Thanks problem resolved.</P></BODY></HTML> Tue, 16 Aug 2011 05:33:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/native-and-open-sql-oracle/m-p/782677#M39368 Former Member 2011-08-16T05:33:02Z