|Oracle 8i Data Cartridge Developer's Guide
Release 2 (8.1.6)
Part Number A76937-01
Methods: Using PL/SQL, 5 of 6
To create a standalone procedure or function, or package specification or body, you must have the
PROCEDURE system privilege to create a procedure or package in your schema, or the
PROCEDURE system privilege to create a procedure or package in another user's schema.
For the compilation of the procedure or package, the owner of the procedure or package must have been explicitly granted the necessary object privileges for all objects referenced within the body of the code. The owner cannot have obtained required privileges through roles.
For more information about privilege requirements for creating procedures and functions, see the chapter about using procedures and packages in the Oracle8i Application Developer's Guide - Fundamentals.