我写了一个存储过程,想在程序调用的给出消息提示,我用了RAISE ,为什么还不行啊,还是没有弹出消息呢,请教各位大狭?
CREATE OR REPLACE PROCEDURE NEWGZGL.p_lei(ss varchar2 )
AS
n_i_status number(1,0);
n_jytpl number(8,2);
myerr exception;
s_msg varchar2(400);
BEGIN
select jytpl into n_jytpl from tk_cpzydzb where id=1;
if nvl(n_jytpl,0)<1000 then
s_msg:='1';
raise myErr;
end if ;
exception
when myerr then
null;
end;
/
CREATE OR REPLACE PROCEDURE NEWGZGL.p_lei(ss varchar2 )
AS
n_i_status number(1,0);
n_jytpl number(8,2);
myerr exception;
s_msg varchar2(400);
BEGIN
select jytpl into n_jytpl from tk_cpzydzb where id=1;
if nvl(n_jytpl,0)<1000 then
s_msg:='1';
raise myErr;
end if ;
exception
when myerr then
null;
end;
/
when myerr then这你写的null,等于异常时什么也没执行啊