User running a query with CHAR datatype Bind variables. In the Bind variable window, he does not enter the enough spaces at the end of the variable to match exactly with the length of the CHAR table column. As a result the Retrieve Results window does not return any data.
The same query returns data running in SQLPlus.
WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Quest SQL Optimizer for Oracle.
To return the correct number of records when executing the SQL without using Retrieve Results, perform the following:
1. Select Options from top-right corner of screen
2. Select Tuning Lab | Execution | Execution Method
3. Select "Run on Server" option
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center