create or replace procedure pr_test_input_only
(vr_test_name in varchar2
)
as
begin
insert into
tb_test
(test_name)
values
(vr_test_name);
COMMIT;
end;Procedure created.
create table tb_test
(test_id number GENERATED ALWAYS AS IDENTITY,
test_name varchar2(50)
)Table created.
declare
vr_Return number;
begin
vr_Return := pr_test_input_only
(vr_test_name => 'pr_test_input_only'
);
end;ORA-06550: line 4, column 16: PLS-00222: no function with name 'PR_TEST_INPUT_ONLY' exists in this scopeMore Details: https://docs.oracle.com/error-help/db/ora-06550