nachs

• Aug 22nd, 2006

 

Use the exception handlers in run time

use sqlerrm, sqlcode functions

show error

is used to find errors during compile time

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 16th, 2008

 

Hi,

what nachs has written is correct.
Show error is use to find the compilation error not run time error.
For runtime error of procedure we need to take help of exception Handling and that error may be user defined or system defined. but we can handle it by mentioning in PL/SQL block itself and will throw the error at run time.

Thanks,