Enabling intra unit inlining

In conventional programming terminology, the program body of an inline program is stored along with the program unit which references it. In context of Oracle subprograms, the term inlining a subprogram refers to the replacing of a subprogram call with the copy of an actual subprogram body itself. At major occasions, this activity cohesively demonstrates better performance and thus, reaps out better benefits along with modularity and call optimization.

Usually, when a program is executed, the PL/SQL engine searches for the program definition in the available objects' lists. It then validates the program, executes the body, and maintains the result in the stack frame. Later it substitutes the results in the calling ...

Get Oracle Advanced PL/SQL Developer Professional Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.