Re: ASP & SQL - Very urgent please!

> I suspect the problem is with the trigger, and below is the trigger
> that I am using.
>
> create or replace trigger makeSequence
> before insert on member
> for each row
> begin
> insert into member values (NEWMEMBERSEQ.nextval, :new.MEMBERSHIP_TYPE,
> :new.FIRSTNAME, :new.MIDDLENAME, :new.LASTNAME,
> :new.ADDRESS, :new.CITY, :new.POSTCODE, :new.TELEPHONE, :new.E_MAIL,
> :new.DATE_OF_BIRTH, :new.START_DATE, :new.INTEREST,
> :new.OBJECTIVE, :new.CURRENT_LEVEL, :new.STATUS, :new.PASSWORD,
> :new.VERIFY_PASSWORD, :new.PAYMENTMETHOD, :new.PERSONAL_TRAINER_ID,
> :new.MEMBERSHIP_ID);
> end;

The trigger is recursive, hence the error message. Your trigger itself causes an insert into the same table, which, in turn, causes the trigger to fire, and so on.

Kirill Received on Tue Mar 19 2002 - 18:58:37 CET