I have been asked to write a document spelling out exactly how we will write PL/SQL for our data warehouse application. I was thinking about recommending the use of inheritance in PL/SQL for error handling, possibly the execute immediate statments, and anything else where we want to keep the logic in one central place.

Does anyone have any thoughts on using inheritance in PL/SQL? Does anyone have any thoughts about creating a centralized error handler with or without using inheritance?