Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01722: invalid number !!

Subhadeep RoyMar 12 2012 — edited Mar 12 2012
Above ora code is a very common one but I am getting this in a very strange situation..!!

I am trying to create the below index

create index ADM.IDX$$_52590003 on ADM.TD_XPORT_R('VID',TO_NUMBER('SETID'))

here VID is a number data type & SETID is a varchar2(2) with data of only ( 0 , 1 & 2)

I checked by searching distinct data as well as checked the length. All seems to be ok.

Though while creating the index I am getting ORA-01722: invalid number. Can anybody help out.

Thanks in advance.

Roy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2012
Added on Mar 12 2012
#bug, #database, #oracle, #sql, #sql-developer
2 comments
485 views