topic SQL_PARSE_ERROR SQL dynamic statement in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/sql-parse-error-sql-dynamic-statement/m-p/10109560#M1815949 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>We are calling dynamic SQL query for data extraction from various tables.</P><P>After transforming the code from ECC60 to ECC60 Ehp7. We encountered the</P><P>below error in one of our custom program.</P><P><BR />&nbsp; The reason for the exception is:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp; The current ABAP program attempted to execute an Open SQL statement&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp; containing a dynamic entry. The parser returned the following error: "You can&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp; only read out of the LRAW or LCHR fiels ZUSR10~AUTHS using its prepending&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>length field"&nbsp; </P><P></P><P>As the code is dynamic we are unable to update the length of field .</P><P>Select (Selected_fields)</P><P>into corresponding fields of Table&nbsp; &lt;tmp_tab&gt;</P><P>from(Table)</P><P>where (where_clause).</P><P></P><P>Please suggest .</P><P></P><P>Thanks</P></BODY></HTML> Mon, 17 Feb 2014 07:40:04 GMT Former Member 2014-02-17T07:40:04Z SQL_PARSE_ERROR SQL dynamic statement https://community.sap.com/t5/application-development-and-automation-discussions/sql-parse-error-sql-dynamic-statement/m-p/10109560#M1815949 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>We are calling dynamic SQL query for data extraction from various tables.</P><P>After transforming the code from ECC60 to ECC60 Ehp7. We encountered the</P><P>below error in one of our custom program.</P><P><BR />&nbsp; The reason for the exception is:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp; The current ABAP program attempted to execute an Open SQL statement&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp; containing a dynamic entry. The parser returned the following error: "You can&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp; only read out of the LRAW or LCHR fiels ZUSR10~AUTHS using its prepending&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>length field"&nbsp; </P><P></P><P>As the code is dynamic we are unable to update the length of field .</P><P>Select (Selected_fields)</P><P>into corresponding fields of Table&nbsp; &lt;tmp_tab&gt;</P><P>from(Table)</P><P>where (where_clause).</P><P></P><P>Please suggest .</P><P></P><P>Thanks</P></BODY></HTML> Mon, 17 Feb 2014 07:40:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sql-parse-error-sql-dynamic-statement/m-p/10109560#M1815949 Former Member 2014-02-17T07:40:04Z Re: SQL_PARSE_ERROR SQL dynamic statement https://community.sap.com/t5/application-development-and-automation-discussions/sql-parse-error-sql-dynamic-statement/m-p/10109561#M1815950 <HTML><HEAD></HEAD><BODY><P>SAP-Note 1810104 describes the problem.</P></BODY></HTML> Wed, 19 Nov 2014 12:09:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/sql-parse-error-sql-dynamic-statement/m-p/10109561#M1815950 frank_hoffmann3 2014-11-19T12:09:54Z