ORA-01722: invalid number - on C program
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01722: invalid number - on C program

  1. #1
    Join Date
    Nov 2000
    Posts
    160
    Good morning all,

    I am executing a C program with sql embeded. This script ran for awhile then hit an error 'ORA-01722: invalid number'. The original programmer wrote this is gone, and I am not very family with C. Now I am trying to track which table and which column having the invalid data to this problem. Can anyone give me suggestion and the steps of how to trace the process of the C program and to trace the source of the causes?

    Here is the error message,

    $ bin/checkadj user pwd
    ****************************************
    * *
    * BEGINNING CHECKADJ TIME = 09:53:12 *
    * *
    ****************************************
    DATE LAST MODIFIED = 19 DEC 00
    CHECKING TM_INDEX INDEX. INDEX OK ..
    CHECKING TM_REF_INDEX INDEX. INDEX OK ..
    CHECKING UNLIQ_INDEX INDEX. INDEX OK ..
    CHECKING UNL_REF_INDEX INDEX. INDEX OK ..
    INTERFUND ADJUSTMENT DC = E2088
    TBO AUTO ADJUSTMENT PRINT LIST - /CHECK.1002
    CAN'T OPEN TRCURS
    >>>>ORA-01722: invalid number <<<<
    >>>> <<<<
    ****************************************
    * *
    * ENDING CHECKADJ TIME = 09:53:23 *
    * *
    ****************************************


    Thanks!

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    1. Can you explain what you infer out of the Output

    2. Check the point on the source code, and see whether the file exits

    Code:
    
              INTERFUND ADJUSTMENT DC = E2088 
              TBO AUTO ADJUSTMENT PRINT LIST - /CHECK.1002 
              CAN'T OPEN TRCURS
    Then check the tables and make sure that you are inserting/updating the colums of those tables with the correct data, i.e. data that does not have any alpha characters in it, some times you may by sending a $ sign with it in the case of a currency value.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width