Calling SQL From PL/SQL - Performance & Integrity
Martin Widlake, ORA600
Calling SQL from PL/SQL - performance and IntegritySQL functionality can be expanded with PL/SQL, primarily with the use of Oracle-provided Built-In package functions or User Defined functions that can be called from SQL. Creating and using your own PL/SQL functions is a powerful and easy-to-use technique.But calling PL/SQL functions from SQL can introduce performance problems, especially if the PL/SQL function itself uses SQL. More significantly, and less well understood, is the fact that this can also cause your SQL to give the wrong results.I'll describe both issues and how from 12c and into 18C you can reduce the performance impact.
Martin is an independent consultant who specialises in Oracle performance, database design, and PL/SQL. He has over 25 years experience, is a member of the Oak Table and an Oracle ACE Director. Martin is also passionate about user groups and exchanging knowledge, attending way too many conferences.