I have an application that constantly monitors the state of an Oracle database. It will, on a timer query for a specific field on a table and take actions on the returned value. The database being down is a possible case I need to handle.

In that case, I get an error from Oracle with a specific description. It's all good from there, but the Err.Number is always the same no matter what (-2147467259). How can I determine what kind of error I am running into ? (other than testing the whole Err.Description)

Thanks !