Re: Capturing Exceptions in Forms 4.0

Dr Fgets wrote:
>
> Hi, I'm trying to capture the "No changes to commit" exception that pops
> up on me, and I can't seem to do it. I've tried this:
> NO_COMMIT EXCEPTION;
> PRAGMA Exception_Init (NO_COMMIT, -40401);
> EXCEPTION
> WHEN NO_COMMIT THEN
> message('blah blah');
> RAISE form_trigger_failure;
> and also WHEN OTHERS and what not, and it doesn't seem to work, can
> someone help me out please?
> -The illustrious DR Fgets

you should read that

>From: Tim McConechy <tmcconec_at_gulf.csc.UVic.CA>
>Subject: Re: d2k -: FRM - 40401 - No changes to save
>
>
>
>Manjula Krishnan wrote:
>
> Hi all:
> why does the form give me this error even though it has commited
> the changes and how can I suppress it?
 

>Issue FORMS_DDL('commit');instead of using COMMIT;. That way you don't have to mess
>with the
>system.message_level.
Received on Tue Mar 24 1998 - 00:00:00 CET