Invalid symbol displayed in select query result

[bluesathish]

hi all,
The following is my select query,

select substr(trim(to_char(AMOUNT, '00000000000.00')),1,11) 
from mytable 
where status_code='V';

I got the right result while I ran this query in Oracle 10g (windows Server), but while i run this same query in Oracle 11g (Linux Server) i got the result as like this
##########. I don't know why this invalid '#' symbol occurs instead of the values. Kindly give your suggestion.

Thanks,
BlueSathish

[rski]

What tool do you use to execute this query? Does it work in sqlplus?

[bluesathish]

Sorry for the delay response, I've used Oracle SQL Developer 3.5, PL/SQL Developer and SQLPlus itself. Everywhere I got this same problem. Kindly help me.

[bluesathish]

I've solved with myself, My oracle data connectivity provider causes this problem. Check out my solution in the below link.

http://www.codeproject.com/Answers/575283/Invalidplussymbolplusdisplayedplusinplusmyplussele