CREATE proc JMO_PRT1_Ins (
@prt_scdn char(65),
@prt_name char(65),
@prt_jno char(5),
@prt_qual char(5),
@prt_seq char(5),
@prt_parm1 varchar(255),
@prt_parm2 varchar(255),
@prt_parm3 varchar(255),
@prt_parm4 varchar(255)
)
as
begin
Insert into jmo_prt1 (
prt_scdn,
prt_name,
prt_jno,
prt_qual,
prt_seq,
prt_parm1,
prt_parm2,
prt_parm3,
prt_parm4
)
Values (
@prt_scdn,
@prt_name,
@prt_jno,
@prt_qual,
@prt_seq,
@prt_parm1,
@prt_parm2,
@prt_parm3,
@prt_parm4
)
end
GO
GRANT EXECUTE ON [dbo].[JMO_PRT1_Ins] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_PRT1_Ins] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_PRT1_Ins] TO [uniadmin]
GO