SELECT DELETE STORED PROCEDURE

This stored procedure will help to select and delete records from table with passing variables.

create or replace PROCEDURE SP_DELETE_DATA (ID IN INTEGER,NAME IN VARCAHR2)
AS

CUR_01_F_COUNT NUMBER ;


CURSOR CUR_01 IS
SELECT COUNT(*)
FROM TABLE_NAME CF
WHERE ID         = ID
AND NAME=NAME;

BEGIN 


OPEN CUR_01;
FETCH CUR_01 INTO CUR_01_F_COUNT;
CLOSE CUR_01;
dbms_output.put_line(' COUNT FOR  IS :'||CUR_01_F_COUNT);

IF CUR_01_F_COUNT > 0 THEN

DELETE FROM TABLE_NAME WHERE ID=ID
AND NAME=NAME;

dbms_output.put_line('REMOVED COUNT IS :'||sql%ROWCOUNT);

IF SQL%ROWCOUNT>0 THEN
COMMIT;
END IF;
END IF;