hi all,
my stored procedure original SQL Server syntax is as follows:
--insert data
CREATE PROC AddTranData
@Tran_Num nchar(20),
@Start_STATION NCHAR(20),
@END_STATION NCHAR(20),
@PIECE INT,
@CONSIGNEE NCHAR(20),
@SHIPPING_ADDRESS NCHAR(50),
@EXPLAINED NCHAR(30)
AS
INSERT INTO TRANSPORT_INFO
VALUES(@TRAN_NUM,@START_STATION,@END_STATION,@PIECE,@CONSIGNEE,@SHIPPING_ADDRESS,@EXPLAINED)
--updated data
CREATE PROC UpdateTranData
@Tran_Num nchar(20),
@Start_STATION NCHAR(20),
@END_STATION NCHAR(20),
@PIECE INT,
@CONSIGNEE NCHAR(20),
@SHIPPING_ADDRESS NCHAR(50),
@EXPLAINED NCHAR(30)
AS
UPDATE TRANSPORT_INFO SETPIECE=@PIECE,CONSIGNEE=@CONSIGNEE,SHIPPING_ADDRESS=@SHIPPING_ADDRESS,
TRAN_NUM=@TRAN_NUM
Now, I want to change it to Stored procedure syntax in oracle.
thanks.