What is an PL/SQL API?
The way that I would define a PL/SQL API is (preferably) one package that provides the interface to one or more underlying tables. Let’s take the EMP table for instance. If I were to define an API for that it would be something like this (pseudocode): • Create Employee • Update Employee • Update Employee Department • Update Employee SalaryAll other code would call one of these procedures/functions to perform the specific action. No one else would write a direct update on EMP, no matter how small or seemingly trivial. If something outside of the 4 defined actions was needed, then it would be added to the preceding package. Why use a PL/SQL API? In all likeliness, the person who is adding the underlying table or tables is going to be the subject matter expert (SME). They should be the ones to define the actions to be performed against that set of tables. Security is a factor here as well. Would you give INSERT/UPDATE/DELETE to non application users or would you require them to use the PL
