How To Approach Error Messages

[muzu1232004]

Hi,

I just want to know that whenever an error occurs such as in pl/sql execution, exporting or importing, or any other oracle server error messages, How to approach and solve the same ? I am feeling a bit difficult of how to approach in a correct way while solving it. It takes a lot of searching without getting solutions in a timely manner. Can anyone suggest about this ?

[amitpatel66]

Please post your SOURCE CODE for reference.
The ERROR handling can be done by:

1. by using exception block with standard EXCEPTIONS raised.
2. user defined EXCEPTION with user defined messages and code.

[debasisdas]

To solve the problem u should know and understand the root cause of the error. Only then u can peoperly debug it.