topic Re: getting error in executing Select options in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/getting-error-in-executing-select-options/m-p/5881714#M1325022 <HTML><HEAD></HEAD><BODY><P>Hi Mahendar!</P><P>I sorry, but the parsed SQL-statement must not exeed a limit of a defined size (is hardcoded restriction of DBMS).</P><P></P><P>A workaround could be to use the SELECT ... FOR ALL ENTRIES-Statement!</P><P>Kind regards</P><P>Peter</P></BODY></HTML> Fri, 10 Jul 2009 07:47:16 GMT Peter_Lintner 2009-07-10T07:47:16Z getting error in executing Select options https://community.sap.com/t5/application-development-and-automation-discussions/getting-error-in-executing-select-options/m-p/5881713#M1325021 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>I am getting error in while executing select options in multiple selection range options in SCASEPS Transaction in PSRM module.</P><P></P><P>suppose I am giving 500 records in a select options ( select single values tab) while executing i am getting message like "; general Error" , i am not getting values.</P><P></P><P>can any body provide the solution.</P><P></P><P>Thanks !</P><P></P><P>Mahendar</P></BODY></HTML> Fri, 10 Jul 2009 07:07:19 GMT https://community.sap.com/t5/application-development-and-automation-discussions/getting-error-in-executing-select-options/m-p/5881713#M1325021 Former Member 2009-07-10T07:07:19Z Re: getting error in executing Select options https://community.sap.com/t5/application-development-and-automation-discussions/getting-error-in-executing-select-options/m-p/5881714#M1325022 <HTML><HEAD></HEAD><BODY><P>Hi Mahendar!</P><P>I sorry, but the parsed SQL-statement must not exeed a limit of a defined size (is hardcoded restriction of DBMS).</P><P></P><P>A workaround could be to use the SELECT ... FOR ALL ENTRIES-Statement!</P><P>Kind regards</P><P>Peter</P></BODY></HTML> Fri, 10 Jul 2009 07:47:16 GMT https://community.sap.com/t5/application-development-and-automation-discussions/getting-error-in-executing-select-options/m-p/5881714#M1325022 Peter_Lintner 2009-07-10T07:47:16Z Re: getting error in executing Select options https://community.sap.com/t5/application-development-and-automation-discussions/getting-error-in-executing-select-options/m-p/5881715#M1325023 <HTML><HEAD></HEAD><BODY><P>done</P></BODY></HTML> Tue, 23 Nov 2010 11:27:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/getting-error-in-executing-select-options/m-p/5881715#M1325023 Former Member 2010-11-23T11:27:01Z Re: getting error in executing Select options https://community.sap.com/t5/application-development-and-automation-discussions/getting-error-in-executing-select-options/m-p/5881716#M1325024 <HTML><HEAD></HEAD><BODY><P>done</P></BODY></HTML> Tue, 23 Nov 2010 11:27:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/getting-error-in-executing-select-options/m-p/5881716#M1325024 Former Member 2010-11-23T11:27:05Z Re: getting error in executing Select options https://community.sap.com/t5/application-development-and-automation-discussions/getting-error-in-executing-select-options/m-p/5881717#M1325025 <HTML><HEAD></HEAD><BODY><P>Use wat he said above.Try using for all entries</P></BODY></HTML> Tue, 23 Nov 2010 11:32:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/getting-error-in-executing-select-options/m-p/5881717#M1325025 Former Member 2010-11-23T11:32:04Z