Hi experts
create table DEL_CUST
(
SNO NUMBER,
CUSTID NUMBER
);
INSERT INTO DEL_CUST VALUES(1,15978);
INSERT INTO DEL_CUST VALUES(2,63248);
INSERT INTO DEL_CUST VALUES(3,56248);
INSERT INTO DEL_CUST VALUES(4,87456);
INSERT INTO DEL_CUST VALUES(5,98745);
COMMIT;
Here I want to delete a multiple custid
if any one custid does't exist then i need to rllback complete without performing any activity.
In below procedure i can able delete only single value at time
please help to pass multiple value through procedure in parameter
create or replace procedure del_cust_sp
(p_custid varchar)
as
begin
delete from del_cust_sp where CUSTID=p_custid;
commit;
end;