When tuning a SQL that very long statement ( OGL system ). An error at the state of GET PLAN was returned:
"ORA-06550: line 2, column 22"
"PLS-00172: string literal too long"
Invalid SQL statement.
Possible causes of this error include:
- The schema for the SQL statement is not selected.
- You are using PL/SQL code or more than one SQL statement.
The Tuning Lab only processes a single .
SELECT/INSERT/DELETE/UPDATE. For multiple SQL statements .
or PL/SQL code, first use the SQL Scanner module to .
extract the SQL statements.
- The parameter from the SQL Scanner - Local Variable
Conversion was not replaced in the SQL statement.==
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center