Oracle deletes data from the View

Oracle deletes the data SQL code www.2cto.com 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 category from individualview where id = idpara and category = CATEGORYPARA; SELECT APPLY_NO into applyno from individualview where id = idpara and category = CATEGORYPARA; if categorypara = '000000' then delete from SSC_EVECT_LOAN_INFO where id = IDPARA; delete from region where id = APPLYNO; elsif categorypara = '000000' then delete from region where id = IDPARA; elsif categorypara = '000000' then delete from SSC_EVECT_EXPENSE_INFO where id = IDPARA; delete from region where id = APPLYNO; elsif categorypara = '000000' then delete from region where id = IDPARA; delete from SSC_DAILY_LOAN_DETAIL_INFO where id = APPLYNO; end if; END;