Re: How to change error_level in Forms?

In article <32AD9F21.4A4E_at_interpath.com>, Ken Denny <kdenny_at_interpath.com> wrote: <snip>
>The second way I found later and like better is to create a stored procedure
>which does nothing but a commit and call that from within forms.
>
>create or replace
>procedure commit_it is
>begin
> commit;
>end;
>/

I like to use Forms_DDL('COMMIT') from within a form. No stored procedure is required.

Steve Cosner

>Now wherever you have a "commit" in your code change it to "commit_it". By
>putting the commit within a stored procedure forms doesn't know about it. I
>have found this trick to be useful for some other things too. For instance, I
>have a procedure called "roll_it_back" which simply does a rollback. The
>reason I do that is because when you do a rollback within a forms trigger it
>clears the screen and I didn't want that to happen.
Received on Wed Dec 11 1996 - 00:00:00 CET