为什么下面这个过程创建不了?create table jj (jid number(2))create or replace procedure adddata(i)as
为什么下面这个过程创建不了?
create table jj (jid number(2));
create or replace procedure adddata(i)
as
begin
insert into jj values(i);
end;
/
警告: 创建的过程带有编译错误。
[解决办法]
- SQL code
create or replace procedure adddata(i in number) as begin insert into jj values(i); commit; end; /
[解决办法]
- SQL code
create or replace procedure adddata(i number) as begin insert into jj values(i); end;
