Using a trigger to insert into a child table

[Quoted] I have a trigger that fires whenever an insert in done on one of my tables. [Quoted] It has been working great, but now I want to use this trigger to insert a [Quoted] [Quoted] some values into a child table. I don't really understand how to do this. [Quoted] This is the code I am using:

[Quoted] Working trigger before the added code:

CREATE OR REPLACE TRIGGER Comp_Id_Trg
  BEFORE INSERT on Company_reg
   FOR EACH ROW
   DECLARE
   Temp Varchar2(30);
   BEGIN
    SELECT Comp_ID_SEQ.NEXTVAL
   INTO Temp FROM DUAL;
   Temp := 'SSCA-'||Temp;
:New.Company_id := Temp;
:New.Phasestat := 'Phase1Begin';
:New.Phase := 'Choose One';
:New.Reason := 'Choose One';

 END Comp_Id_Trg;
/

Now This is what I am trying to do but can't seem to get the code right:

CREATE OR REPLACE TRIGGER Comp_Id_Trg
  BEFORE INSERT on Company_reg
   FOR EACH ROW
   DECLARE
   Temp Varchar2(30);
   Temp2 Number;
   BEGIN
    SELECT Comp_ID_SEQ.NEXTVAL
   INTO Temp FROM DUAL;
   Temp := 'SSCA-'||Temp;
:New.Company_id := Temp;
:New.Phasestat := 'Phase1Begin';
:New.Phase := 'Choose One';
:New.Reason := 'Choose One';

    SELECT Con_ID_SEQ.NEXTVAL
    INTO Temp2 FROM DUAL;
    Insert INTO CON_INFO
(CON_ID,COMPANY_ID,CON_MAIL1,CON_MAIL2,CON_DIRCALL,PHS1FORM_FAX,PHS1FORM_EMA IL, UNSOLCALL,
    PHSFORM_COURIER, PHSFORM_RECBACK, PHSFORM_INPUTED, PHSFORM_WEBSITE, CON_VALQ1INFO, CON_PARTICIPATION, PHASE2PRE_CALLEDCOMP, [Quoted] CALLCOMPLETED, PHS2FAX, PHS2EMAIL, PHS2COURIER, PHS2RECBACK, PHS2INPUTTED, PHS2WEBSITE) VALUES (Temp2, 'Temp',
[Quoted] [Quoted] 1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

 END Comp_Id_Trg;
/

Can anyone tell me what I am doing wrong. This gives me a unique constraint error.

Thanks,
Jeff Received on Mon Apr 09 2001 - 17:28:39 CEST