我编了一个简单的存储过程 create or replace procedure testYxm
(
testvalue out number
)
is
begin
insert into test1 values(5,'test5')
returning 1 into testvalue;
commit;
end;
运行老是 无效SQL语句看了半天不知道怎么回事,请指点。
(
testvalue out number
)
is
begin
insert into test1 values(5,'test5')
returning 1 into testvalue;
commit;
end;
运行老是 无效SQL语句看了半天不知道怎么回事,请指点。
SQL> declare
2 a number;
3 begin
4 testYxm(a);
5 DBMS_OUTPUT.put_line(a);
6 end;
7 /
1PL/SQL procedure successfully completed
is
begin
insert into d values(5)
returning 1 into testvalue;
commit;
end;
create or replace procedure testYxm
is
begin
insert into test1 values(1,'test');
commit;
end;但我又写了一个
create or replace procedure yxm.testyxm
is
begin
create table test55(sid number, sname varchar2(20));
commit;
end;
还是 创建的过程带有编译错误
怎么回事呀
execute immediate 'create table test55(sid number, sname varchar2(20))';
commit;
..