Padding blank spaces behing the passed string in Oracle
Posted: Mon May 12, 2008 1:19 am
Hello All,
I have found that using APT_ORACLE_PRESERVE_BLANK = True option also Pads blank spaces behing the passed string.
i.e. eventhough i pass only 5 or 6 or 7 characters to a field defined as Varchar2(12) in database
it is actually stored as 12 instead of 5 or 6 or 7 characters padding blank spaces behind the sting which causes problem while lookup.
Database: Oracle 10i
Wrtite Mode: LOAD -> truncate
tried all sort of way like trim,trimb or trimF or index of left but did not work etc...
Please suggest how to resolve this issue.
Thank You
I have found that using APT_ORACLE_PRESERVE_BLANK = True option also Pads blank spaces behing the passed string.
i.e. eventhough i pass only 5 or 6 or 7 characters to a field defined as Varchar2(12) in database
it is actually stored as 12 instead of 5 or 6 or 7 characters padding blank spaces behind the sting which causes problem while lookup.
Database: Oracle 10i
Wrtite Mode: LOAD -> truncate
tried all sort of way like trim,trimb or trimF or index of left but did not work etc...
Please suggest how to resolve this issue.
Thank You