December 2002
Intermediate to advanced
928 pages
85h 29m
English
CREATE [OR REPLACE] PROCEDUREname[ (parameter[,parameter]) ] [AUTHID {CURRENT_USER | DEFINER} ] [DETERMINISTIC] {IS | AS}declaration_sectionBEGINexecutable_section[EXCEPTIONexception_section] END [name];
Program unit, or module, that execute one or more statements and that can receive or return zero or more values through its parameter list. You can call a procedure as a standalone executable PL/SQL statement as shown in this example:
apply_discount(new_company_id, 0.15) --15% discount
Common keywords: AGGREGATE USING, AUTHID, DETERMINISTIC, PARALLEL_ENABLE, and PIPELINED.