ALTER
PROCEDURE [dbo].[InsertMessage]
@Message_Gb nvarchar(1000),
@Message_Big5 nvarchar(1000),
@Message_En nvarchar(1000),
@Message_Tg nvarchar(1000),
@Message_Jp nvarchar(1000),
@Message_Krw nvarchar(1000),
@Message_Vnd nvarchar(1000),
@Active int = 1 ,
@Show_Time int = 120,
@CLass nvarchar(10)='C',
@ZuBie nvarchar(10)='A'
AS
declare@Message_id nvarchar(20)
declare@End_Datetime datetime
update Message set Active =0 where Active = @Active and Class = @Class
set @End_Datetime = DATEADD ( mi , @Show_Time, getdate() )
execGetId 'X', '',@Message_idoutput
insert Message(Message_id,Message_Gb,Message_Big5,Message_En,Message_Tg,Message_Jp,Message_KRW,Message_Vnd,Active,Datetime,End_Datetime,CLASS)
values(@Message_id,@Message_Gb,@Message_Big5,@Message_En,@Message_Tg,@Message_Jp,@Message_Krw,@Message_Vnd,@Active,getdate(),@End_Datetime,@CLass)
select 1 //存储过程返回值
这段sql2008存储过程转成Oracle 11g存储过程应该写成什么样?
|
