Re: Very Urgent: Trigger Compilation Errors

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Tue, 16 Nov 1999 19:11:35 +0100
Message-ID: <80s6pb$16t97$1@fu-berlin.de>

Hi,

try a select * from user_errors

after compilation

Bye
Uli

Michael Duffy <duffym_at_hotmail.com> schrieb in im Newsbeitrag: e_fY3.1882$C4.91037_at_news1-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 - 12:11:35 CST