Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
PLS-00172: string literal too long when trying to optimize a long SQL statement
Description
I have a single SQL statement that is very long that I am trying to optimizer (in this case, more then 500 lines). But in Tuning Lab, when I click the "Optimize" button, it starts to process, but after a second or two, I get the following error:
"The Parser did not identify the text as a valid SQL statement.
<SQL Snippet...>
ORA-06550: line2, column22: PLS-00172: string literal too long
Invalid SQL statement. Verify that you have selected the right schema. Only one SQL statement can be optimized in this window. To analyze PL/SQL code or multiple SQL statements use the SQL Scanner."
The statement runs in SQL Plus, it is the right schema, and it is only a single SQL statement. Can the Tuning Lab handle a SQL statement this large?
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
Your Request will be reviewed by our technical reviewer team and, if approved, will be added as a Topic in our Knowledgebase.
Welcome to Quest Support
You can find online support help for Quest *product* on an affiliate support site. Click continue to be directed to the correct support content and assistance for *product*.
The Quest Software Portal no longer supports IE8, 9, & 10 and it is recommended to upgrade your browser to the latest version of Internet Explorer or Chrome.