number and varchar

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.

Sent via Deja.com
http://www.deja.com/ Received on Wed Dec 13 2000 - 21:08:21 CST