sql ´æ´¢¹ý³Ì תΪ oracle ´æ´¢¹ý³Ì

ALTER  PROCEDURE Xp_WriteCorpInput
(--±¾´æ´¢¹ý³ÌÓÃÓÚ¼ÈëÔËÓªÉ̵ÄÌìÆøÏûÏ¢
@UserID  varchar(20), -- ²Ù×÷Ô±
@CorpID varchar (20), -- ÔËÓªÉÌID
@ClassCode varchar (20), -- ÒµÎñ±àºÅ
@PlaceCode varchar (20), -- µØÇø±àÂë
@Contents varchar (400), -- ÏûÏ¢ÄÚÈÝ
@Pri varchar (20), -- ÏûÏ¢ÓÅÏȼ¶
@EffectTime varchar (20), -- ÏûÏ¢ÓÐЧʱ¼ä
@PublishTime varchar (20), -- ÏûÏ¢·¢²¼Ê±¼ä
@ret int output-- ·µ»Ø½á¹û
)--@ret  0  ³É¹¦
--      1  ¸ù¾ÝPlaceCodeºÍClassCodeûÕÒµ½Æ¥ÅäµÄ¼Ç¼
--      2  ûÓÐȨÏÞ
--      3  ÓÅÏȼ¶Ì«µÍ
--      4  ÒѾ­¹ýʱ
AS
declare @MsgID int -- 
declare @MobileMsgID int -- 
declare @FID int -- fid

declare @OldPri int
declare @now datetime
declare @oldEffectTime datetime
select @ret = 0 --SUCCESS
select @MsgID = 0
set @MobileMsgID = 0
set @FID  = 0
declare @OprType varchar(10)


--ÏÈͨ¹ý´úÂë´ÓÖú¼Ç·ûÖвéÕÒPlaceCode
   
if not exists(select * from tbl_CityInfo WHERE FplaceCode=@PlaceCode)
begin
  select @ret = 1 --ERROR
  return
end
--Print @PlaceCode

if not exists (select FID from t_CorpTempMsg WHERE FCropID = @CorpID and FPlaceCode=@PlaceCode AND FClassCode=@Cla