如题 怎么将Sqlserver中的存储过程转换为Oracle啊 我上网搜了 自己改了还是不行 我有例子 请高手指点一下啊。
ALTER PROCEDURE dbo.Get4City
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT top 4 * FROM HQXH_M_CITY order by CITY_ID desc
END //这是一个例子
ALTER PROCEDURE dbo.InsertAssNews
@ASS_TITLE varchar(MAX),
@ASS_CONTENT varchar(MAX),
@ASS_DATE datetime
AS
BEGIN transaction
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON; -- Insert statements for procedure here
INSERT INTO HQXH.dbo.HQXH_M_AFFICHE
(AFFICHE_TITLE
,AFFICHE_CONTENT
,AFFICHE_DATE)
VALUES
(@ASS_TITLE,
@ASS_CONTENT,
@ASS_DATE)
IF @@error <> 0
BEGIN
ROLLBACK TRANSACTION;
RETURN
END COMMIT TRANSACTION //这个也是一个 这2个都改不好 求高手指教啊!!
ALTER PROCEDURE dbo.Get4City
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SELECT top 4 * FROM HQXH_M_CITY order by CITY_ID desc
END //这是一个例子
ALTER PROCEDURE dbo.InsertAssNews
@ASS_TITLE varchar(MAX),
@ASS_CONTENT varchar(MAX),
@ASS_DATE datetime
AS
BEGIN transaction
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON; -- Insert statements for procedure here
INSERT INTO HQXH.dbo.HQXH_M_AFFICHE
(AFFICHE_TITLE
,AFFICHE_CONTENT
,AFFICHE_DATE)
VALUES
(@ASS_TITLE,
@ASS_CONTENT,
@ASS_DATE)
IF @@error <> 0
BEGIN
ROLLBACK TRANSACTION;
RETURN
END COMMIT TRANSACTION //这个也是一个 这2个都改不好 求高手指教啊!!
begin
insert into hqxh.hqxh_m_affiche (affiche_title, affiche_content, affiche_date)
values (ass_title, ass_content, ass_date);
Commit;
exception
when others then
RollBack;
end insertassnews;
/