You have bad data in that column, or if that column is indexed, there
may be a problem with the index.
If the column is indexed, then rebuild the index. If not, you have to
figure out which row has the bad data and delete it.
HTH.
-----Original Message-----
From: Perikala Satish [mailto:[Email address protected]
Sent: Friday, July 16, 2004 11:07 AM
To: Seefelt, Beth
Subject: RE: ORA-01722: invalid number
**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text
It is throwing the same error.
Reg
SS
-----Original Message-----
From: Seefelt Beth
[mailto:oracledba-ezmlmshield-x68214320.[Email address protected]
Sent: Friday, July 16, 2004 8:12 PM
To: LazyDBA Discussion
Subject: RE: ORA-01722: invalid number
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
--------
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