Invalid result in SQL SCAN when the select statement is too long. The same select statement with fewer data in the "where" clause is valid. The error details shows:
ORA-0064: error occurred at recursive SQL level 1
ORA-01461: can bind a LONG value only for insert into a LONG column
Incorrect plan table definition in Optimizer.
WORKAROUND
Use the attached "GOOD_EXPLAIN_PLAN" .
a. Compile "GOOD_EXPLAIN_PLAN" in the database.
b. Launch Quest SQL Optimizer for Oracle | Go to Options at the top right corner.
c. Go to General | Options | Select "Use the following plan table" | Provide the information for step a.
d. Click OK
STATUS
Waiting for fix in a future release of Quest SQL Optimizer for Oracle
Quest SQL Optimizer for Oracle 8.7 is expected to be released on the last week of September 2012.
