Calling PL/SQL from SQL – Performance and Integrity
PL/SQL and SQL naturally work well together. We can use PL/SQL to extend SQL in any way we want. A PL/SQL function is treated by SQL as though it is part of the language and gives us great flexibility to improve and simplify our code.
However, there are performance considerations with calling PL/SQL from SQL. In this presentation I cover those concerns and also enhancements in Oracle 12c & 11g that improve performance.
There are also dangers with calling PL/SQL functions from SQL which can give unexpected (and sometimes wrong) results – which are often overlooked. I explain those issues and how you can avoid them.