Problem creating surrogate key

[Atanas The dude]

Hi,
I am trying to create a surrogate key so for that purpose I have this sequence:

CREATE SEQUENCE Author_Seq INCREMENT BY 1 START WITH 1 MINVALUE 1

but when I try to create the following trigger:

CREATE OR REPLACE TRIGGER author_sur BEFORE INSERT ON AUTHOR FOR EACH ROW WHEN (NEW.ID IS NULL) BEGIN :NEW.ID := Author_Seq.NEXTVAL; END;

I get IN- or OUT-parameter is missing at index:: 1. Any idea why this happens?

[Avi Abrami]

Atanas The,
You need to change the body of the trigger.
A simple Internet search for the terms "oracle", "trigger", "nextval" will provide the answer.
Try the following:
SELECT Author_Seq.NEXTVAL INTO :new.id FROM dual;
Good Luck,
Avi.