When trying to tune a query that contains a CAST function who's second argument is quantified with a schema, the "schema_name.table_name" in "CAST(schame_name.pkg_name.function_name ('41') AS schema_name.table_name)", the following error is returned.
"This type of SQL statement is not supported."
WORKAROUND:
To avoid the problem, the second argument of the CAST function should not contain any schema-quantified type. So, log into (or set schema to) the schema of the casting type and then change the SQL to remove the schema from the casting type.
STATUS:
This issue is fixed in SQL Optimizer for Oracle 7.2. This version can be downloaded here.
