Your numbers have Characters and spaces in them?





-----Original Message-----
From: Perikala Satish
[mailto:oracledba-ezmlmshield-x56648940.[Email address protected]
Sent: Friday, July 16, 2004 8:28 AM
To: LazyDBA Discussion
Subject: ORA-01722: invalid number



Hi All,
=20
Please look at the following...
=20
SQL> desc WARR_STG.ACC_OLAP_WARR_UNITS_FACT
Name Null? Type
----------------------------------------- --------
----------------------------
TOTAL_WARRANTY_QT NUMBER
DATE_DIM_KY
NUMBER
GEOGRAPHY_DIM_KY NOT NULL NUMBER(38)
ORIG_PRODUCT_DIM_KY NOT NULL NUMBER(38)
ORIG_PRODUCT_NR
VARCHAR2(18)
ORIG_PART_NR
CHAR(1)
ACC_PRODUCT_DIM_KY NOT NULL NUMBER(38)
ACC_PRODUCT_NR
VARCHAR2(18)
ACC_PART_NR
CHAR(1)
YEAR_MONTH
VARCHAR2(6)
HP_CTRY_CD
VARCHAR2(3)
=20
=20
SQL> select count(*) from WARR_STG.ACC_OLAP_WARR_UNITS_FACT
2 where ORIG_PRODUCT_DIM_KY =3D 555703300;
where ORIG_PRODUCT_DIM_KY =3D 555703300
*
ERROR at line 2:
ORA-01722: invalid number

What could be the wrong here??


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page