hello, every one here.

I have two schema in my database Oracle8.0.6/solaris.

I run following sql in both of schemas.

desc t_order

orderCd varchar(10);
...

select 1 from t_order where orderCd = 000000001;

in first schema , it returned

no record fetched.

in another schema, it returned

ORA-01722 ....

Who can explain why it happend and how can I solute this problem.

Thanks a lot.