Programming Oracle® Triggers and Stored Procedures, Third Edition

9.2. Referencing Oracle Packages

Each language has syntax for referencing other program units. The C programming language uses an INCLUDE directive to reference header files.

#include <stdio.h>
#include <stdlib.h>

Perl scripts call procedures in the Windows32 library with a USE WIN32 directive.

use Win32::Registry;
use Win32::OLE;

Java classes import whole packages and package classes.

package project.students;
import java.io.*;
import java.util.*;
import java.sql.*;
import oracle.sql.*;
import oracle.jdbc.*; 
import project.util.*;

With each of these environments, it is a task to locate the library code you need and make sure it is in your path. PL/SQL does not require a compiler directive to use other packages. If you want to write PL/SQL ...