sql ditor에서 실행하면
declare에러라고 나오는데 어떤게 잘못된건지
잘모르겠습니다.
고수님들의 답변바랍니다.
create procedure "ums".addnewsubmit(
in_submittime varchar(14), -- submit time --
in_srcaddr varchar(18), -- MIN number --
in_srctype varchar(6), -- source type --
in_destaddr varchar(32),
in_gid integer,
in_dests integer, -- 착신 수 --
in_limit integer, -- 착신 재시도 횟수--
in_svctype varchar(10), -- 서비스 종류 --
in_defmsgid integer, -- default msgid --
in_encoding varchar(10), -- Encoding type --
in_length integer, -- 메시지 길이 --
in_content varchar(255), -- MSG Content --
in_frontend varchar(6), --착신종류 --
in_scheduletime varchar(14), --예약시간 --
in_desttype varchar(6) --Dest type --
)
returning integer ;
define return_status integer ;
define out_MsgId integer ; --return MsgId --
--as
begin
let out_MsgId = (select MAX( US_MSGID )+1 from UMS_SUBMIT) ;
if ( out_MsgId > 0 ) then
--
declare tmp integer ; --obsolete --
else let out_MsgId=0 ;
end if
INSERT INTO UMS_SUBMIT(
US_MSGID,
US_SUBMITTIME,
US_SRCADDR,
US_SRCTYPE,
US_DESTADDR,
US_GID,
US_DESTS,
US_SUCCEEDS,
US_FAILS,
US_LIMIT,
US_SVCTYPE,
US_DEFMSGID,
US_ENCODING,
US_LENGTH,
US_CONTENT)
VALUES (
out_MsgId,
in_submittime,
in_srcaddr,
in_srctype,
in_destaddr,
in_gid,
in_dests,
0,
0,
in_limit,
in_svctype,
in_defmsgid,
in_encoding,
in_length,
in_content) ;
EXECUTE PROCEDURE AddNewDelivery (
out_MsgId,
1,
in_frontend,
0,
in_scheduletime,
in_destaddr,
in_desttype) ;
end
return out_MsgId ;
end procedure
;
grant execute on "ums".addnewsubmit to "public" as "ums";
여기까지입니다..
|