Re: Very Urgent: Strange behaviour of triggers

Hi Michael,

Are you sure the versions of the Database are the same on the test and the development database?
possible causes could indeed be missing synonyms or different grants to those synonyms. Although i must say i always get some kind of error message...

Is there a difference in installation between the 2 databases...

Wim

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 - 15:11:45 CST