Hi Team,
I have created below procedure in which i am passing values as in parameter and then the in parameter is used in my where clause in select query.
I call the procedure by single value as input parameter.Now i want to pass multiple values as IN parameter to the same procedure.
Procedure Code :-----
CREATE OR REPLACE PROCEDURE test_procedure(lp_id in number) AS
begin
insert intoTABLE_C(ID)
select ID from TABLE_A
where ID=lp_id
and ID not in(select ID from TABLE_B
where ID=lp_id
);
commit;
END test_procedure;
Calling Procedure :----
begin
test_procedure(100);
end;
Requirement :---
Now my select query should be using IN clasue as
select ID from TABLE_A
where ID in (lp_id)
and ID not in(select ID from TABLE_B
where ID in (lp_id)
and assuming the procedure to call values as arrays like
begin
test_procedure(100,200,300);
end;