Handle Exception « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Handle Exception
1.A procedure that uses a WHEN OTHERS clause
2.Check and output sqlcode sqlerrm
3.noroom exception
4.Generic error handling to handle any type of error
5.Use exception handler to mark success flag