RE: Trigger problem

Must we understand that the trigger happens to be on the 'COMPANY' table ? Make it either a statement (instead of row) trigger - not sure it suits your requirements - or remove COMPANY from the SELECT and replace references to the columns from COMPANY by :new.column.

HTH SF

>----- ------- Original Message ------- -----
>From: Zsolt Csillag <info_at_starsoft.hu>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>Sent: Fri, 18 Apr 2003 06:20:49
>
>
>
>
>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: Stephane Faroult
  INET: sfaroult_at_oriolecorp.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
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).