Prompted for bind variable that is not there when referencing an object type (4246791)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Prompted for bind variable that is not there when referencing an object type
Description

When running alternatives returned from optimizing SQL, if it contains a reference to an object type, the object type will be confused as a bind variable and SQL Optimizer prompts users to enter a value for that bind variable.
Cause

Object Types are not supported by SQL Optimizer.
Resolution

WORKAROUND:

If possible, remove the object reference in the SQL before optimizing. Once you have found a better alternative, you may add the object reference back to the alternative SQL.

STATUS:
Waiting for this enhancement to be implemented in a future version of SQL Optimizer.
Defect ID

ST40487

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title