过程 函数 包

过程：

CREATE OR REPLACE PROCEDURE PROCEDURE_NAME(       rec_ IN OUT person_info_tab%ROWTYPE,       person_id_ IN VARCHAR2(20))IS       person_name_ VARCHAR2(50);BEGIN       .......       .......       .......END PROCEDURE_NAME;

函数：

CREATE OR REPLACE FUNCTION FUNCTION_NAME(       rec_ IN person_info_tab%ROWTYPE,       person_id_ IN VARCHAR2(20))IS       person_name_ VARCHAR2(50);BEGIN       .......       .......       .......       RETURN (person_name_);END FUNCTION_NAME;

包：

CREATE OR REPLACE PACKAGE BODY PACKAGE_NAMEIS       person_name_ VARCHAR2(50);       函数       过程END PACKAGE_NAME;