一个入门sp错误,请指教.
第一次做oracle sp , compiler失败.
请教各位.
代码如下
create or replace procedure spname
as
begin
insert into test_guye
values(2);
end;
执行:
execute sp_name
错误 :
Error(3,3): PLS-00103: Encountered the symbol "" when expecting one of the following: ( ; is with authid as cluster compress order using compiled wrapped external deterministic parallel_enable pipelined