存储过程调用不成功,求解决
存储过程创建:
create procedure procedure_test is
begin
select * from dual;
end;
调用方法1:
call procedure_test
报错:not a valid function or procedure name
调用方法2:
begin
procedure_test;
end;
报错:
ORA-06550:line 2, column 1:
PLS-00905:object TEST.PROCEDURE_TEST is invalid
ORA-06550:line 2, column 1:
PL/SQL:Statement ignored