I create a trigger to automatically insert '-9999' into a column.
The code is like this:

CREATE OR REPLACE TRIGGER PERSONNEL_BSTATEMENT
BEFORE INSERT ON L_NWS_PERSONNEL
BEGIN
INSERT INTO L_NWS_PERSONNEL (GREMPID_KEY)
VALUES ('-9999');
END PERSONNEL_BSTATEMENT;

When I load data to fire this trigger, the error message comes out like this:

ORA-00036 Maximum number of recursive SQL level (50) exceeded.

I go to Oracle 9i online documentation. It only says to delete the trigger. Please help to tell me the reason. Thanks.

Frank