这个过程是用PLSQL Developer 写的, 为什么在"procedures"目录下,图标上面总是有一个红色的"X"create or replace procedure p_AddAction
(v_name in VARCHAR2(50),
v_desc in VARCHAR2(200),
v_AffectRow out int
)
is
begin
insert into tb_action
( action_name, action_desc)
values
( v_name, v_desc);
v_AffectRow:=sql%rowcount;
commit;
end p_AddAction;
/
(v_name in VARCHAR2(50),
v_desc in VARCHAR2(200),
v_AffectRow out int
)
is
begin
insert into tb_action
( action_name, action_desc)
values
( v_name, v_desc);
v_AffectRow:=sql%rowcount;
commit;
end p_AddAction;
/
(v_name in VARCHAR2,
v_desc in VARCHAR2,
v_AffectRow out int
)
is
begin
insert into tb_action
( action_name, action_desc)
values
( v_name, v_desc);
v_AffectRow:=sql%rowcount;
commit;
end p_AddAction;
/