Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Trigger problem

Re: Trigger problem

From: Barbara Boehmer <baboehme_at_hotmail.com>
Date: 7 Jun 2005 12:57:30 -0700
Message-ID: <1118174250.382581.20400@g49g2000cwa.googlegroups.com>


I re-read your last post and it is very difficult to understand exactly what you are trying to do and what you are asking. Is TABAPPOGGIOSTAMPAFATTURE an external table? If so, that would explain why you are getting null values. The trigger will not fire when an external table is created. You would need to create a new table of the same structure as your external table and create the trigger on the new table, not the external table, then do an insert from your external table to your new table. Received on Tue Jun 07 2005 - 14:57:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US