Error Trapping Forms 5

I have a timecard/payroll application written in Forms 5. The administrator is able to prevent users from updating one of the tables periodically. I did this by using forms_ddl to revoke insert,update and delete privileges from the users' role for the table in question when the administrator clicks a button. When the administrator wants to allow the users to update the table again I use forms_ddl to grant the necessary privileges back to the users' role for that same table. Works fine... The problem is the ugly system error message (Frm-40508, Ora- 01031) I get if a user tries to update that table while the privileges have been revoked. I created an exception and a pragma to catch ORA- 01031(insufficient privileges). That works as well, but I still get the System error message FIRST on an insert. The Forms severity level is
>25 and

apparently Forms ignores suppression of severe or vital errors. Any ideas on how to stop this system error message? Thank you in advance.

Dan Webb
webbde_at_post.queensu.ca

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Feb 10 2000 - 19:04:18 CET