Re: Very Urgent: Strange behaviour of triggers

Sounds like you don't have the grants needed. Also, instead of show errors, try

select * from user_errors

Michael Duffy <duffym_at_hotmail.com> wrote in message news:1lgY3.1554$lZ.78061_at_news2-hme0...
> Database: Oracle 7.3.4 on NT
>
> I am trying to create a series of triggers on a development server on a
> customer site.
> These have just been created successfully on the test server.
>
> The triggers copy data from one schema to another. The tables in both
> schemas are identical.
>
> When I run the triggers on the dev server I get a compilation error. When
I
> say show errors,
> the 'no errors' message is reported back.
>
>
> I have tried dropping the triggers and recreating them, and also dropping
> and recreating the public synonyms, but I still get the same error.
> As a last resort, even the server was rebooted, again to no avail.
>
> Does anyone know what the likely cause of this problem is, and more
> importantly, what can be done to rectify the situation.
>
>
>
> Keith Jamieson
>
>
>
>
Received on Tue Nov 16 1999 - 13:05:26 CST