ORA-01722: invalid number - on C program

[Unna]

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!

[sambavan]

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

          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