SQL Language (MOSC)

MOSC Banner

Ora-1722 - Invalid number

edited Jul 3, 2012 5:44AM in SQL Language (MOSC) 4 comments
Hi, Folks.

     I have a table called s_BENNER.TEMP_FURNASIMPORTABENEFICIARIO with the following structure:

Nome                        Nulo     Tipo         
--------------------------- -------- -------------
HANDLE                      NOT NULL NUMBER(10)   
Z_GRUPO                              NUMBER(10)   
C1C1TIPOREGISTRO                     VARCHAR2(1)  
C1694C1696_CONVENIO                  VARCHAR2(3)  
NOMEARQUIVO                          VARCHAR2(100)
C186C187                             VARCHAR2(2)  


  When I run the query below:

SELECT HANDLE,C186C187,TO_NUMBER(C186C187)
        FROM S_BENNER.TEMP_FURNASIMPORTABENEFICIARIO
        WHERE NOMEARQUIVO LIKE '\\10.1.0.154\TRANSF_BENNER\BENEFICIARIOS\IMPORTACAO\1B270612.TXT'
                    AND SUBSTR(C13C21,3,7)='0158185';

It returns:

    HANDLE C186C187 TO_NUMBER(C186C187)
---------- -------- -------------------
    188266 00                         0
    188267 01                         1

But , when I want to return only 'C186C187' = 0  as Number, it occurs an error ORA-1722 as below

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center