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

Home -> Community -> Usenet -> c.d.o.server -> Re: Help on Insert Triggers

Re: Help on Insert Triggers

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 08 Nov 2005 10:41:18 -0800
Message-ID: <1131475282.352302@yasure>


johnparcels_at_gmail.com wrote:
> When I tried to create this trigger, I am getting this error message?
>
> ORA-30506: system triggers cannot be based on tables or views
> Cause: An attempt was made to base a system trigger on a table or a
> view.
> Action: Make sure the type of the trigger is compatible with the base
> object.
>
> Any Ideas?

Two to be precise.

  1. Post your Oracle version
  2. Post your code -- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)
Received on Tue Nov 08 2005 - 12:41:18 CST

Original text of this message

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