Error executing query: "ORA-06502: PL/SQL: numeric or value error: character string buffer too sm (4223520)

The following error occurs when executing original or alternate query in Optimizer:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512

Query executes successfully outside of Optimizer.

Large text values containing quotation marks.

WORKAROUND:
Rewrite query to split the large text values into separate Where clauses.

For example, one large IN clause rewritten to three different smaller IN clauses:
From:
...AND <column name> IN (1111111, 222222, ...,999999)
To:
...AND (<column name> IN (1111111, 222222, ...)
OR <column name> IN ( 444444, 5555555, ....)
OR <column name> IN ( 888888, 9999999,....))



STATUS:
Issue fixed in version Quest SQL Optimizer for Oracle 7.5.3. The latest version of  SQL Optimizer for Oracle  can be downloaded at: https://support.quest.com/Search/SearchDownloads.aspx