Re: Problem creating trigger

In article <35BEEA75.D71B1B52_at_exlibris.co.il>,   Ariel Kirson <arielk_at_exlibris.co.il> wrote:
> (Oracle7 Server Release 7.3.3.0.0 - Production Release
> With the distributed option
> PL/SQL Release 2.3.3.0.0 - Production)
>
> Hi all,
>
> I have been trying to create a trigger on one of
> our tables, but I am repeatedly receiving the
> following message :
>
> Warning: Trigger created with compilation errors.
>
> I have based the creation script on one of our existing
> scripts, which seems to work fine.
> I am aware that I have not given you enough information
> to find the specific problem, but I would like to know
> where I can find information on "Troubleshooting", or
> "FAQs" on creating triggers.
> So far I have looked in my "Server SQL Lan. Ref. Man."
> with no success.
>
> I would appreciate any help.
>
> Thanks in advance,
>
> Ariel Kirson
> Ex Libris.
>
>

Try to type the following command in your SQL Plus prompt:

SHOW ERRORS TRIGGER Trigger_name;

The errors will appear in next lines.

OK?

Victor - Brasil

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sun Aug 02 1998 - 12:28:43 CDT