Hi Guys,

Thanks for the previouse post, which helped me to find the issue.
I have find one more important thing about the CharacterSet of the Database.

I got the same issue when migrating my DB to Oracle 11G. And got the same issue as mentioned in the thread.

My Solution:
We build the DB with the character set : - AMERICAN_AMERICA.WE8ISO8859P15 [non-unicode]. Which accepts the more than 2 char/varchar type output parameters, hense resolved the issue.