SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Auto Trim of input function values

575607May 30 2007 — edited May 31 2007

G'day,

We've encountered a strange behaviour (we'll to us it is), in that on one oracle server while running queries and pl/sql statements through Oracle HTML DB v2 it appears that the input values to RPAD, LPAD, REPLACE are having their values trimed. For example RPAD(FIRSTNAME, 50, ' ') || LASTNAME is not padding with spaces. This is when we tried to LPAD LASTNAME and it failed then we use '*' and called REPLACE(val, '*', ' ') and that failed to pad.

However when we run it on a separate Oracle 10g server via Oracle worksheets the SQL queries work as expected.

Can anyone shed any light on if there is a SESSION option or Database option that has been defaulted as on (ie AUTOTRIM true) ???

Regards
Mark

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 28 2007

Added on May 30 2007

11 comments

1,064 views