Procedure

From Oracle FAQ
Jump to: navigation, search

A procedure is a block of PL/SQL code named and stored within the database.

[edit] Example

CREATE OR REPLACE PROCEDURE raise_sal(i_empno NUMBER, i_newsal NUMBER)
AS
BEGIN
  UPDATE emp SET sal = i_newsal WHERE empno = i_empno;
END;

[edit] Also see

Glossary of Terms
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #