Question

sql存储过程怎么转为oracle存储过程？

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER PROCEDURE [dbo].[cc_begin_scrapUC]
(
@id varchar(64),
@item varchar(128),
@qty decimal(18, 8),
@measure_code varchar(64),
@warehouse varchar(64),
@code varchar(64),
@bom_ver varchar(64),
@transaction_date datetime,
@update_user_id varchar(64),
@remark varchar(256),
@company varchar(64)
)
AS
SET NOCOUNT OFF;
UPDATE [cc_begin_scrap] SET [item] = @item, [qty] = @qty, [measure_code] = @measure_code, [warehouse] = @warehouse, [code] = @code, [bom_ver] = @bom_ver, [transaction_date] = @transaction_date, [update_user_id] = @update_user_id, [update_date] = getdate(), [remark] = @remark, [company] = @company
WHERE (id = @id)
SELECT id, item, qty, measure_code, warehouse, code, bom_ver, transaction_date, create_user_id, create_date, update_user_id, update_date, remark, company FROM cc_begin_scrap WHERE (id = @id)

Answer 1

两者的语法不同，要按照oracle的语法重新写一遍

追问

可不可以帮忙写一下，我没有学过oracle