IS
TYPE V_CUR IS REF CURSOR;
T_REC_jdgrslt tq_jdgrslt%ROWTYPE; PROCEDURE P_REFER (
P_DCS_TIME_FROM IN VARCHAR2
,P_DCS_TIME_TO IN VARCHAR2
,P_SMP_NO IN VARCHAR2
,P_CUR OUT V_CUR
);
PROCEDURE P_GET_INFO (
P_PLATE_ID IN VARCHAR2
,P_E_CODE OUT NUMBER
,P_E_MSG OUT VARCHAR2
);
PROCEDURE P_MODIFY (
ITYPE IN VARCHAR2
,P_PROD_NO IN TQ_JDGRSLT.PROD_NO%TYPE DEFAULT NULL
,P_CTOS_STL_GRD IN TQ_JDGRSLT.CTOS_STL_GRD%TYPE DEFAULT NULL
,P_CTOS_STD_SPEC IN TQ_JDGRSLT.CTOS_STD_SPEC%TYPE DEFAULT NULL
,P_APP_DGR IN TQ_JDGRSLT.APP_DGR%TYPE DEFAULT NULL
,P_CHEM_DGR IN TQ_JDGRSLT.CHEM_DGR%TYPE DEFAULT NULL
,P_MTAL_DGR IN TQ_JDGRSLT.MTAL_DGR%TYPE DEFAULT NULL
,P_PROD_DGR IN TQ_JDGRSLT.PROD_DGR%TYPE DEFAULT NULL
,p_WOO_RSN in TQ_JDGRSLT.WOO_RSN%TYPE DEFAULT NULL
,P_EMP_ID in VARCHAR2
,P_E_CODE OUT NUMBER
,P_E_MSG OUT VARCHAR2
);
PROCEDURE P_ONEROW (
p_SCHEDULE_ID IN VARCHAR2
,P_CUR OUT V_CUR
);
PROCEDURE P_REFER3 (
P_PROD_NO IN TQ_JDGRSLT.PROD_NO%TYPE DEFAULT NULL
,P_CUR OUT V_CUR
);
END Pkg_QTTIC;
TYPE V_CUR IS REF CURSOR;
T_REC_jdgrslt tq_jdgrslt%ROWTYPE; PROCEDURE P_REFER (
P_DCS_TIME_FROM IN VARCHAR2
,P_DCS_TIME_TO IN VARCHAR2
,P_SMP_NO IN VARCHAR2
,P_CUR OUT V_CUR
);
PROCEDURE P_GET_INFO (
P_PLATE_ID IN VARCHAR2
,P_E_CODE OUT NUMBER
,P_E_MSG OUT VARCHAR2
);
PROCEDURE P_MODIFY (
ITYPE IN VARCHAR2
,P_PROD_NO IN TQ_JDGRSLT.PROD_NO%TYPE DEFAULT NULL
,P_CTOS_STL_GRD IN TQ_JDGRSLT.CTOS_STL_GRD%TYPE DEFAULT NULL
,P_CTOS_STD_SPEC IN TQ_JDGRSLT.CTOS_STD_SPEC%TYPE DEFAULT NULL
,P_APP_DGR IN TQ_JDGRSLT.APP_DGR%TYPE DEFAULT NULL
,P_CHEM_DGR IN TQ_JDGRSLT.CHEM_DGR%TYPE DEFAULT NULL
,P_MTAL_DGR IN TQ_JDGRSLT.MTAL_DGR%TYPE DEFAULT NULL
,P_PROD_DGR IN TQ_JDGRSLT.PROD_DGR%TYPE DEFAULT NULL
,p_WOO_RSN in TQ_JDGRSLT.WOO_RSN%TYPE DEFAULT NULL
,P_EMP_ID in VARCHAR2
,P_E_CODE OUT NUMBER
,P_E_MSG OUT VARCHAR2
);
PROCEDURE P_ONEROW (
p_SCHEDULE_ID IN VARCHAR2
,P_CUR OUT V_CUR
);
PROCEDURE P_REFER3 (
P_PROD_NO IN TQ_JDGRSLT.PROD_NO%TYPE DEFAULT NULL
,P_CUR OUT V_CUR
);
END Pkg_QTTIC;
查查REF CURSOR的用法
以及
存储过程的定义方法。
建议读《Oracle数据库应用开发基础》,清华大学出版社。
当然任何一本Oracle的书,都会有部分内容来介绍PL/SQL的。