What happens if you

select ORIG_PRODUCT_DIM_KY from WARR_STG.ACC_OLAP_WARR_UNITS_FACT;

?

beth

-----Original Message-----
From: Perikala Satish
[mailto:oracledba-ezmlmshield-x56648940.[Email address protected]
Sent: Friday, July 16, 2004 10: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


The information contained in this e-mail message is confidential, may
be legally privileged, and is intended for use only by the individual(s)
named above. If you are not the intended recipient of this message, you
must not copy, forward, disclose or otherwise use it, or any part of
it, in any way whatsoever. If you have received this message in error,
please notify the sender immediately by return e-mail and delete the
message and any attachments from your system. Thank you

Oracle LazyDBA home page