PL/SQL Stored Procedures
Stored procedures are called blocks that allow grouping and organization of SQL and PL/SQL commands.
CREATE OR REPLACE PROCEDURE proc_name (paramater_name datatype, ...) IS BEGIN -- pl/sql statement END;
Parameters are used to transfer data between values and call the procedure.
Parameters can have one of 3 ways: IN, OUT and IN OUT.
Example Stored Procedure:
CREATE OR REPLACE PROCEDURE upd_address (p_id IN NUMBER, p_address IN VARCHAR2) IS BEGIN UPDATE students SET address= p_address WHERE student_id = p_id; END;