Triggers from SQL SERver to Oracle

I have a bunch of triggers in SQl Server that I need to move over to Oracle 8i.

But when I run it in Sql Plus I get nowhere. Any thoughts on why this doesn;t work or general syntax differences (declaring variables, etc) between SQl Server and Oracle

my trigger is:

CREATE TRIGGER InsertSeries ON dbo.Survey_Series FOR INSERT
AS
DECLARE
@Prevmax_id int,
@Survey_series_id int

SELECT @Prevmax_id = 0

SELECT @Survey_series_id = Survey_series_id FROM inserted

SELECT @Prevmax_id = MAX(Survey_Series.Survey_series_sequence_id) FROM Survey_Series

UPDATE Survey_Series SET

		Survey_series_sequence_id = @Prevmax_id + 1,
		Update_datetime  = getdate() ,
		Update_username = app_name()
		WHERE Survey_series_id = @Survey_series_id

Thanks,
rdalfonso_at_nyc.rr.com Received on Wed Sep 18 2002 - 15:23:56 CDT