Stored procedure syntax in oracle

Question

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.