We have a Visual Basic application that uses ODBC to connect to the database. When the database has been up and running for a few months we start getting problems using ODBC. On connecting to the database we get numeric value errors, but we can connect via sqlplus OK. We don't get any errors from the alert.log.

We have found that if I issue the command 'alter system flush shared pool;', or stop/start the database, the errors disappear. Does anyone have any ideas? Thanks.