in reply to
Difference in retrieving values from a varchar2 column and number column from DB
What happened to the art of debugging? Is it dead? Not taught? Not described in books? Ignored?
So you've got a 700 lines script using god only knows how long modules connecting to a database started by cron. So what? Start it directly. Add some debug prints. Trim it down. Do something!
You can't expect us to spoonfeed you a fix in code we haven't seen, in a script we can't run.
Enoch was right!
Enjoy the last years of Rome.