Oracle-L: RE: Trigger problem

From: Pardee, Roy E <roy.e.pardee_at_lmco.com>
Date: Fri, 18 Apr 2003 09:03:22 -0800
Message-ID: <F001.00584DB0.20030418090322@fatcity.com>

I'm not seeing any references to the :new or :old cursors--can you make this a statement level trigger (e.g., leave off the FOR EACH ROW bit)? I believe that would prevent the error.

HTH,
-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-----Original Message-----

Sent: Friday, April 18, 2003 7:21 AM
To: Multiple recipients of list ORACLE-L

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).
--

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

Author: Pardee, Roy E
INET: roy.e.pardee_at_lmco.com

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