Sql> CREATE OR REPLACE PROCEDURE query_emp
(id IN employees.employee_id%TYPE,
name OUT employees.last_name%TYPE,
salary OUT employees.salary%TYPE) IS
BEGIN
SELECT last_name, salary INTO name, salary
FROM employees
WHERE employee_id =...
Wednesday, October 3, 2012
Procedure with Parameters
An IN parameter (the default) provides values for a subprogram to process.
An OUT parameter returns a value to the caller.
An IN OUT parameter supplies an input value, which may be returned (output) as a modified value.
CREATE OR REPLACE PROCEDURE raise_salary
(id IN employees.employee_id%TYPE,
...
What Is a Procedure?
What Is a Procedure?
A procedure: Is a type of subprogram that performs an action
Can be stored in the database as a schema object
Promotes reusability and maintainability
CREATE [OR REPLACE] PROCEDURE procedure_name
[(parameter1 [mode] datatype1,
parameter2 [mode] datatype2, ...)]
IS|AS
[local_variable_declarations;...
