Hi, I created these objects:
-------------------------------
create table mwallet.tb_test
(test_id number GENERATED ALWAYS AS IDENTITY,
test_name varchar2(50)
);
-------------------------------
create or replace procedure test_user.pr_test_input_only
(vr_test_name in varchar2
)
as
begin
insert into
test_user.tb_test(test_name)
values (vr_test_name);
COMMIT;
end;
-------------------------------
I tried to execute the procedure as "test_user" with all privilegies and code:
declare
vr_Return number;
begin
vr_Return := mwallet.pr_test_input_only
(vr_test_name => 'pr_test_input_only'
);
end;
and it returns me:
Error report -
ORA-06550: line 4, column 16:
PLS-00222: no function with name 'PR_TEST_INPUT_ONLY' exists in this scope
ORA-06550: line 4, column 3:
PL/SQL: Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
*Action:
-------------------------------
Any ideas why it doesn't works ?