Very Urgent: Trigger Compilation Errors

From: Michael Duffy <duffym_at_hotmail.com>
Date: Tue, 16 Nov 1999 16:53:35 -0000
Message-ID: <e_fY3.1882$C4.91037@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 - 10:53:35 CST