Chapter Nine. The PL/SQL Environment

9.1 A HELLO WORLD PROGRAM

9.2 REFERENCING ORACLE PACKAGES

9.2.1 Creation of the Environment

9.2.2 The API

9.3 USER_OBJECTS

9.4 DEPENDENCIES AMONG PROCEDURES

9.5 USER_DEPENDENCIES

9.6 USER_SOURCE

9.7 SHARING CODE

9.8 COMPILATION DEPENDENCY

9.8.1 Scenario 1

9.8.2 Scenario 2

9.9 USER_ERRORS

For traditional compiler languages, such as C, we write our source code and then compile it. We may choose from one of several compilers. The compilation produces a second file—an object file. We then use a linker to link one or more objects into an executable. The compile and link process leaves us with our source, several object files, and an executable image that is executed under the control of the operating system. The finished ...

Get Programming Oracle® Triggers and Stored Procedures, Third Edition 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.

Start your free trial