Stored Procedures [dbo].[JMO_PRT_Ins]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@prt_scdnchar(65)65
@prt_namechar(65)65
@prt_jnochar(5)5
@prt_qualchar(5)5
@prt_seqchar(5)5
@prt_parm1varchar(255)255
@prt_parm2varchar(255)255
@prt_parm3varchar(255)255
@prt_parm4varchar(255)255
Permissions
TypeActionOwning Principal
GrantExecuteemadmin
GrantExecutejmoadmin
GrantExecuteuniadmin
SQL Script
/****** Object:  Stored Procedure dbo.JMO_PRT_Ins    Script Date: 12/1/2005 11:49:24 PM ******/


CREATE proc JMO_PRT_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_prt (
      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_PRT_Ins] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRT_Ins] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRT_Ins] TO [uniadmin]
GO
Uses