Trigger problem

From: Zsolt Csillag <info_at_starsoft.hu>
Date: Fri, 18 Apr 2003 06:20:50 -0800
Message-ID: <F001.00584C0E.20030418062050@fatcity.com>

Hello,

I have created an after update trigger for each row.

This trigger calls a procedure that inserts a row in a table using a select statement eg.

     Insert Into Free_Sie_Internal
       (Free_Sie_Internal_Fo_Kulcs,
        Free_Sie_Internal_Entity,
        Free_Sie_Internal_Kulcs_Tipus,
        Free_Sie_Internal_Kulcsszavak)

       Select Company.Company_Cnr,
              Company_Entity.Company_Entity_Entity2,
              'COMPANY',
              Company.Company_Name || ' ' || Type.Type_Text || ' ' ||
              Address.Address_Street || ' ' || Address.Address_Street_Nr || 
' ' ||
              Contact.Contact_Firstname || ' ' || 

Contact.Contact_Secondname Name

         From Company, Address, Type, Contact, Company_Entity
        Where Company.Company_Cnr = Address.Address_Cnr(+) And
              Address.Address_City1 = Type.Type_Code1(+) And
              Address.Address_City2 = Type.Type_Code2(+)

              And Address.Address_Unique = 
Contact.Contact_Address_Unique(+) And
              Company.Company_Cnr = Company_Entity.Company_Entity_Cnr;

This trigger doesn't work because I've got an error message ORA-04091 company is mutating trigger/function may not see it.

It is very important to have this select statement in this trigger.

Is there a way to work around this?

Thank you in advance

Zsolt Csillag
Hungary

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Zsolt Csillag
  INET: info_at_starsoft.hu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Apr 18 2003 - 09:20:50 CDT