Auto Compiling Procedures
Creating and Using Standalone Procedures and Functions
4-4 Oracle Database 2 Day Developer's Guide
4.
The
ADD_EVALUATION
pane opens with the following code.
Note that the tile of the pane is in italic font, which indicates that the procedure is
not saved in the database.
CREATE OR REPLACE
PROCEDURE ADD_EVALUATION
( evaluation_id IN NUMBER
, employee_id IN NUMBER
, evaluation_date IN DATE
, job_id IN VARCHAR2
, manager_id IN NUMBER
, department_id IN NUMBER
) AS
BEGIN
NULL;
END ADD_EVALUATION;
5.
From the File menu, select Save to save the new procedures. Alternatively, use the
CTRL + S
key combination.
Note that Oracle Database automatically compiles procedures prior to saving
them.
