Hi!
I have ready method it's working now when I input one id.
declare
p_account_no varchar2(16);
v_amt_catchup_ioa number := 0;
BEGIN
p_account_no := '11002140014766';
BEGIN
v_amt_catchup_ioa := report_methods.get_o_amt_catchup_ioa(p_account_no);
EXCEPTION
WHEN NO_DATA_FOUND THEN
v_amt_catchup_ioa := 0;
END;
dbms_output.put_line(v_amt_catchup_ioa);
END LN1022_amt_catchup_ioa;
Now I want input more then one id like bellow:
declare
p_account_no varchar2(16);
v_amt_catchup_ioa number := 0;
BEGIN
p_account_no := '11002140014766','11002140014767','21002140014766';
BEGIN
v_amt_catchup_ioa := report_methods.get_o_amt_catchup_ioa(p_account_no);
EXCEPTION
WHEN NO_DATA_FOUND THEN
v_amt_catchup_ioa := 0;
END;
dbms_output.put_line(v_amt_catchup_ioa);
END LN1022_amt_catchup_ioa;
How its possible input more id in method?
