入园第一篇

CREATE OR REPLACE PROCEDURE PRO_MID_DIV(P_BILLING_CYCLE IN NUMBER,P_LATN_ID IN NUMBER) IS
V_TABLE_NAME   VARCHAR2(50);
V_SQLSTATMENT  VARCHAR2(2048);
V_SQLCODE      VARCHAR2(10);
V_SQLERRM      VARCHAR2(1000);
V_tmp_TABLE2  VARCHAR2(50);
V_tmp_TABLE3  VARCHAR2(50);
V_tmp_TABLE4  VARCHAR2(50);
V_TABLE_NAME1  VARCHAR2(200);

BEGIN


END;

  /****************************START异常处理**********************************/
    EXCEPTION
        WHEN OTHERS THEN
          ROLLBACK;
          V_SQLCODE:=SQLCODE;
          V_SQLERRM:=SQLERRM;
          INSERT INTO PRO_ERROR_LOG VALUES('PRO_MID_DIV','PRO_MID_DIV异常',V_SQLCODE,V_SQLERRM,SYSDATE);
          COMMIT;
    /****************************END异常处理**********************************/        
END PRO_MID_DIV;

SQL> col type for a10;
SQL> select type,name,description from v$lock_type where rownum<5;

TYPE NAME DESCRIPTION
---------- ------------------------------ ----------------------------------------------------------------------------------------------------
WM WLM Plan Operations Synchronizes new WLM Plan activation
CI Cross-Instance Call Invocation Coordinates cross-instance function invocations
PR Process Startup Synchronizes process startup
AK GES Deadlock Test Lock used for internal testing

SQL>