tracking ORA errors.

[T sandya]

hi friends,
In any enterprise applications we will get ORA errors like below on browser,

ORA-01008: not all variables bound

some users know what is the problem it is and why it is coming,but some users don't know.To know all i want to track that error and i want to give user friendly message for console users,what's the problem exactly it is.how can i achive that.

thanks in advance.

regards,
sandya.

[Marcelo Ortega]

Hi T Sandya,
These are standard Oracle database errors, which you receive through your JDBC connection (as the message in the exception thrown). What we do at Contactel ltd is create a properties file with the error code as the key and a user-friendly explanation as the value. Then all you need to do is, when
you receive an exception from a data base operation, parse the msgException received and use it as the key into the properties file, where you will find the user-friendly explanation.

Regards.