Re: Problem creating trigger

From: <iolo_at_my-dejanews.com>
Date: Wed, 29 Jul 1998 15:42:31 GMT
Message-ID: <6pnft7$qnd$1@nnrp1.dejanews.com>

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.
>
>

Shalom Ariel,

do a

Select * from user_errors

right after getting the compilation error message - that'll show you where the problems might be.

--
Oliver Willandsen
European Commission
http://europa.eu.int
All remarks are my own and do not necessarily reflect official European Commission policy

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Jul 29 1998 - 10:42:31 CDT