Re: trigger...
From: <rtproffitt_at_my-deja.com>
Date: Mon, 18 Sep 2000 15:33:56 GMT
Message-ID: <8q5cl3$krg$1_at_nnrp1.deja.com>
Date: Mon, 18 Sep 2000 15:33:56 GMT
Message-ID: <8q5cl3$krg$1_at_nnrp1.deja.com>
Raise_Application_Error(-20xxx, 'error text'); Number is more negative that -20000... e.g. -20001, -20100, etc.
Robert Proffitt
In article <8q52db$605$1_at_news.ipartners.pl>,
"Lukasz Feldman" <lukasz_at_atm.com.pl> wrote:
> Hello!
>
> I have a task to write a trigger which will check before update some
tables.
> As a result of this checking it will give user permission to update a
column
> or
> not a will show an error...
> It's not a problem to check some tables bu which sys procedure I
should you
> to
> generate an error and stop the process of update.
>
> Lukasz
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Sep 18 2000 - 17:33:56 CEST