When I send a query to SQL Optimizer from Toad and select 'Batch Optimize,' a 'Check Connection' windows pops up with the message:
"Datatype is not supported" in the message field.
The could be cause by unsupported Oracle client (e.g. Oracle 7.3.4).
Please consult the Release Notes of you version of SQL Optimizer to make sure you are using supported Oracle client and server.
The Release Notes can be downloaded from http://support.quest.com or from the default install path 'C:\Program Files\Quest Software\Quest SQL Optimizer for Oracle\Documentation.'