This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
Martin Widlake

Calling SQL From PL/SQL - Performance & Integrity


Martin Widlake, ORA600


 

Abstract

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. 

Speaker Biography

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.