Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

A. Nuijten, P. BarelModern Oracle Database Programminghttps://doi.org/10.1007/978-1-4842-9166-5_10

10. Calling PL/SQL from SQL

Alex Nuijten¹   and Patrick Barel²

(1)

Oosterhout, Noord-Brabant, The Netherlands

(2)

Almere, Flevoland, The Netherlands

 

Calling a reusable piece of code stored in a PL/SQL function—packaged or stand-alone—results in a context switch. The SQL engine stops whatever it is doing and gives control to the PL/SQL engine, which then does its work and returns control to the SQL engine after it’s done. These context switches are relatively expensive. They involve a lot of work by both engines to transfer all the relative information before the ...