Re: Help on Insert Triggers

Thank you for help.
10.1.0.4.0

Create or replace trigger mytrigger
before drop on TableA
for each row
begin
 Insert into TableB
values(:old.ColID,:old.Col1,:old.Col2,:old.Col3,:old.Col4,:old.Col5,:old.Col6); exception
  when DUP_VAL_ON_INDEX then
   null;
end;
/

DA Morgan wrote:
> 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 - 14:27:51 CST