Index and length must refer to a location within the string, Parameter name: length on complex query (4262052)

Using the “Get Plan” for a complex SQL, the following error is returned:

"Index and length must refer to a location within the string"
"Parameter name: length"

The error only happens on a complex query.

This does not error on a simple query..

WORKAROUND:
None

STATUS:

Issue fixed in version SQL Optimizer for Oracle 8.0.

The latest version of SQL Optimizer can be downloaded here.

The latest version of Toad for Oracle can be downloaded here.