create or replace package demo as
procedure test(a_num_param in number);
procedure test(a_num2_param in number);
end; Package created.
create or replace package body demo as
procedure test(a_num_param in number) is
begin
dbms_output.put_line('1');
end;
procedure test(a_num2_param in number) is
begin
dbms_output.put_line('2');
end;
end; Package Body created.
exec demo.test(a_num_param => 1)Statement processed.
1
exec demo.test(a_num2_param => 1)Statement processed.
2
exec demo.test(1)ORA-06550: line 1, column 7: PLS-00307: too many declarations of 'TEST' match this callMore Details: https://docs.oracle.com/error-help/db/ora-06550