No CLOB in datatype dropdown list in Setting Bind Variables (4257170)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

No CLOB in datatype dropdown list in Setting Bind Variables
Description

While analyzing SQL for re-write, the optimizer pops up a new window for ‘Setting Bind Variables’. CLOB does not exist as option for data-type.
Resolution

Quest SQL Optimizer for Oracle does not include CLOB in the list of available datatypes for the variable binding because user can use the VARCHAR2 datatype to obtain the same result. CLOB and VARCHAR2 can be implicitly converted by Oracle so the user can choose VARCHAR2 as the bind variable datatype for the CLOB variables.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title