Re: Trigger problem

From: <devlishh1_at_my-deja.com>
Date: Mon, 14 Aug 2000 20:20:08 GMT
Message-ID: <8n9k9h$g5q$1@nnrp1.deja.com>

Where are you using this trigger? In forms or reports? The raise_application_error is for sql on the server side. You will get another error if using it in a client application. You can use this function in procedures and packages run on the server and then have an exection handler on the client side to catch the error number and message you define in the raise_application_error and display it from the client application. Hope this helps.

In article <8n91of$fk$1_at_nnrp1.deja.com>, tigrans_at_my-deja.com wrote:
> Why if I write in trigger raise_application_error(-
20101, "Some_text");
> Oracle raised an error message
>
> Can you help me ?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Aug 14 2000 - 15:20:08 CDT