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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center