ASP & SQL - Very urgent please!

Hi Everybody,

I have a problem with inserting records into an oracle database, could you please help?
This is the error that I am getting and I have no idea what the problem is. Please advise!

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) [Oracle][ODBC][Ora]ORA-00036: maximum number of recursive SQL levels (50) exceeded ORA-06512: at "MJ864.MAKESEQUENCE", line 2 ORA-04088: error during execution of trigger 'MJ864.MAKESEQUENCE' ORA-06512: at "MJ864.MAKESEQUENCE", line 2 ORA-04088: error during execution of trigger 'MJ864.MAKESEQUENCE' ORA-06512: at "MJ864.MAKESEQUENCE", line 2 ORA-04088: error during execution of trigger 'MJ864.MAKESEQUENCE' ORA-06512: at "MJ864.MAKESEQUENCE", line 2 ORA-04088: error during execution of trigger 'MJ864.MAKESE
/~mj864/newmember/acknowledge.asp, line 71

The line 71 that this refers to is

MyConn.Execute "INSERT INTO MEMBER (memberID, membership_type, firstName, middleName, lastName, address, city, postcode, telephone, e_mail, date_of_birth, start_date, interest, objective, password, verify_password, paymentmethod, personal_trainer_id, membership_id) VALUES ('"&Request.Form("memberID")&"','"&Request.Form("membership_type")&"','"&Request.Form("firstName")&"','"&Request.Form("middleName")&"','"&Request.Form("lastName")&"','"&Request.Form("address")&"','"&Request.Form("city")&"','"&RequestForm("postcode")&"','"&Request.Form("telephone")&"','"&Request.Form("e_mail")&"','"&Request.Form("date_of_birth")&"','"&Request.Form("start_date")&"','"&Request Form("interest")&"','"&Request.Form("objective")&"','"&Request.Form("password")&"','"&Request.Form("verify_password")&"','"&Request.Form("Paymentmethod")&"','"&Request.Form("personal_trainer_id")&"','"&Request.Form("membership_id")&"')"

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;
/

Your help will be much appreciated.

Many thanks,

Judith Received on Mon Mar 18 2002 - 21:31:30 CET