Skip to Main Content
Forums

SQL & PL/SQL

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-01722 in a number column

user455466Feb 15 2025 — edited Feb 15 2025

Hi,

How can I know the value of IMP_TARIFA column for the 'AAAJ6rAAAAAAAsiACJ' rowid?

SQL> select rowid, COD_SOLICITUD, COD_CORPORATIVO, IMP_TARIFA, NVL( IMP_TARIFA, 99999), dump(IMP_TARIFA) du
  2  from  TDFA.TDFA_PERSTARIFA  where rowid in ( CHARTOROWID('AAAJ6rAAAAAAAsiACJ'), CHARTOROWID('AAAJ6rAAAAAAAsiACI'));

OWID              COD_SOLICITUD COD_CORPORATIVO  IMP_TARIFA NVL(IMP_TARIFA,99999)	DU
------------------ ------------- --------------- ---------- ---------------------   ----------------------------------
AAAJ6rAAAAAAAsiACI         60309             123                            99999   NULL
AAAJ6rAAAAAAAsiACJ         60309             123                                    Typ=2 Len=3: 191,3,1


SQL> SELECT to_number(IMP_TARIFA)  FROM TDFA.TDFA_PERSTARIFA where rowid = CHARTOROWID('AAAJ6rAAAAAAAsiACJ');
                 *
ERROR en linea 1:
ORA-01722: numero no valido

SQL> desc TDFA.TDFA_PERSTARIFA
 Nombre                                    ?Nulo?   Tipo
 ----------------------------------------- -------- ----------------------------
 COD_SOLICITUD                             NOT NULL NUMBER(10)
 COD_CORPORATIVO                                    NUMBER(6)
 COD_AGRUPACION                                     NUMBER(6)
 FEC_ULTMODIF                              NOT NULL DATE
 COD_USRMODIF                              NOT NULL VARCHAR2(8)
 COD_CONCEPTO                                       NUMBER(18)
 IMP_TARIFA                                         NUMBER(18,8)
 IMP_EST_LLAMADA                                    NUMBER(18,8)
 IND_UNIVOL                                         VARCHAR2(3)
 IMP_ESTEXCFRAN                                     NUMBER(18,8)
 IMP_EXCFRAN                                        NUMBER(18,8)
 IND_UNIEXCFRAN                                     VARCHAR2(3)
 NUM_UNIEXCFRAN                                     NUMBER(10)
 COD_ESTADO                                NOT NULL VARCHAR2(2)

Thanks & Regards.
This post has been answered by Jonathan Lewis on Feb 15 2025
Jump to Answer

Comments

Processing

Post Details

Added on Feb 15 2025
#ora-01722
1 comment
69 views