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??

Oracle LazyDBA home page