读书人

不包含参数的存储过程应该怎么建立

发布时间: 2012-01-15 22:57:49 作者: rapoo

不包含参数的存储过程应该如何建立?

create or replace package Pac_Test
as
procedure Pro_DelAndUpd();
end Pac_test;
/
Commit;
/

create or replace package body Pac_Test
as
procedure Pro_DelAndUpd
is
begin
update t_test set name = name || ' is updated ';
delete from t_test where id = 1001;
dbms_lock.sleep(1);
RAISE_APPLICATION_ERROR(-1, '大哥,出错了! ');
end Pro_DelAndUpd;
end Pac_Test;
/
Commit;
/

----------------------------

显示错误:

3/32 PLS-00103: 出现符号 ") "在需要下列之一时:
<an identifier>
<a double-quoted delimited-identifier> current


[解决办法]
改了一下:


create or replace package Pac_Test
as
procedure Pro_DelAndUpd;
end Pac_test;


create or replace package body Pac_Test
as
procedure Pro_DelAndUpd
is
begin
update t_test set name = name || ' is updated ';
delete from t_test where id = 1001;
dbms_lock.sleep(1);
RAISE_APPLICATION_ERROR(-1, '大哥,出错了! ');
end Pro_DelAndUpd;
end Pac_Test;

读书人网 >oracle

热点推荐