PROCEDURE [schema.]name[( parameter[, parameter...] ) ]

　　[AUTHID DEFINER | CURRENT_USER ]

　　[ACCESSIBLE BY (program_unit_list)]

IS

　　[declarations]

BEGIN

　　executable statements

　　[ EXCEPTION

　　exception handlers]

END [name];

FUNCTION [schema.]name[( parameter[, parameter...] ) ]

　　RETURN return_datatype

　　[AUTHID DEFINER | CURRENT_USER]

　　[DETERMINISTIC]

　　[PARALLEL_ENABLE ...]

　　[PIPELINED]

　　[RESULT_CACHE ...]

　　[ACCESSIBLE BY (program_unit_list)

　　[AGGREGATE ...]

　　[EXTERNAL ...]

IS

　　[declaration statements]

BEGIN

　　executable statements

　　[EXCEPTION

　　exception handler statements]

END [name];