Getting "ORA-06550" when using auto optimize.
Example of the error:
"ORA-06550: line 85, column 7: PLS-00386: type mismatch found at 'COL26' between FETCH cursor and INTO variables ORA-06550: line 59, column 4: PL/SQL: SQL Statement ignored ORA-06550: line 126, column 10: PLS-00386: type mismatch found at 'COL26' between FETCH cursor and INTO variables ORA-06550: line 100, column 7: PL/SQL: SQL Statement ignored " as status for all the scenarios.
WORKAROUND 1
Change to use "Run on client" mode instead to test run SQL. To do so, open the Options window,
- under Optimize SQL | Batch Run | Batch Run Settings, select "Predefined Settings"
- then go under Optimize SQL | Batch Run | Batch Run Settings, select "custom Settings".
WORKAROUND 2
Update the SQL to not select the XMLTYPE column
STATUS
Waiting for fix in a future release of SQL Optimizer for Oracle
