Creating a Procedure with GUI Menu
Creating and Using Standalone Procedures and Functions
Developing and Using Stored Procedures 4-3
CREATE OR REPLACE
procedure_name
(
arg1
data_type,
...) AS
BEGIN
....
END
procedure_name
;
To create a procedure:
You will create a procedure
add_evaluation
that creates a new row in the
evaluations
table.
1.
In the Connections navigation hierarchy, right-click Procedures.
2.
Select New Procedure.
3.
In the New Procedure window, set the following parameters:
Ensure that Schema is set to
HR
.
Set Name to
ADD_EVALUATION
.
In the Parameters tab, click the Add Column icon ('plus' sign) and specify the first
parameter of the procedure. Set Name to
eval_id
, set Type to
NUMBER
, set Mode
to
IN
, and leave Default Value empty.
Similarly, add the following parameters, in this order:
employee_id
: set Type to
NUMBER
, set Mode to
IN
, and leave Default Value
empty.
evaluation_date
: set Type to
DATE
, set Mode to
IN
, and leave Default
Value
empty.
job_id
: set Type to
VARCHAR2
, set Mode to
IN
, and leave Default Value
empty.
manager_id
: set Type to
NUMBER
, set Mode to
IN
, and leave Default Value
empty
department_id
: set Type to
NUMBER
, set Mode to
IN
, and leave Default
Value
empty
Click OK.
