Re: Trigger at the Schema level - not working

Thomas Kellerer <spam_eater_at_gmx.net> wrote in message news:<bs90lb$apksk$1_at_ID-13919.news.uni-berlin.de>...
> Jawahar Rajan schrieb:
>
> > All,
> > I am trying to use the following trigger. It is a Schema level trigger, that
> > should run each time a table is created.
> > I am trying to create a shadow table for eachnew table created. However I
> > get an error that say I do not have permissions?
> >
> > Any ideas why
> > The error:
> > ERROR at line 1:
> > ORA-00604: error occurred at recursive SQL level 1
> > ORA-01031: insufficient privileges
> > ORA-06512: at line 39
> >
> > Do I need tobe a DBA to get the trigger to fire?
> > Any Suggestions welcome
> >
> > Jawahar
>
> I'm not familiar with schema level triggers, so maybe there is something I'm
> missing, but wouldn't your trigger cause an infinite loop?
>
> You are creating a table in there which in turn, will fire the trigger which
> will create a shadow table for your shadow table and so on...
>
> Thomas

look at line 39 of your trigger code. what do you have insufficient trigger on?

ORA-06512: at line 39

work from there. Received on Tue Dec 23 2003 - 09:25:23 CST