oracle 删视图,Oracle删除视图中的数据

CREATE OR REPLACE PROCEDURE "INDI_DEL_PRO" (IDPARA IN INDIVIDUALVIEW.ID%TYPE, CATEGORYPARA IN INDIVIDUALVIEW.CATEGORY%TYPE, RETURNPARA OUT NUMBER)

AS

APPLYNO INDIVIDUALVIEW.APPLY_NO%TYPE;

BEGIN

SELECT COUNT(*) INTO RETURNPARA FROM INDIVIDUALVIEW WHERE ID=IDPARA AND CATEGORY=CATEGORYPARA;

SELECT APPLY_NO INTO APPLYNO FROM INDIVIDUALVIEW WHERE ID=IDPARA AND CATEGORY=CATEGORYPARA;

IF CATEGORYPARA= '1001'THEN

DELETE FROM SSC_EVECT_LOAN_INFO WHERE ID=IDPARA;

DELETE FROM SSC_DAILY_LOAN_DETAIL_INFO WHERE ID=APPLYNO;

ELSIF CATEGORYPARA= '1002'THEN

DELETE FROM SSC_DAILY_LOAN_INFO WHERE ID=IDPARA;

ELSIF CATEGORYPARA= '1003'THEN

DELETE FROM SSC_EVECT_EXPENSE_INFO WHERE ID=IDPARA;

DELETE FROM SSC_EVECT_EXPENSE_DETAIL_INFO WHERE ID=APPLYNO;

ELSIF CATEGORYPARA= '1004'THEN

DELETE FROM SSC_DAILY_EXPENSE_INFO WHERE ID=IDPARA;

DELETE FROM SSC_DAILY_LOAN_DETAIL_INFO WHERE ID=APPLYNO;

END IF;

END;