Re: Forms commit lying

tmg_at_calweb.com wrote:
>We have a database with several forms that has been working find for several
>months. Suddenly the application appears to working find however all the data
>changes aren't getting to the database. The forms are reporting the all
>changes have been commited but when we query the DB, the changes aren't there.
>Any ideas.
>
>TIA
Each time I have encountered this problem, the problem was caused by poor coding practices. There are several things you can do to locate and eliminate the problem.

1. Check to see if the on-error trigger is being used? The on-error triggers are useful, but novice forms designers often use the on-error trigger to ignore errors. Make sure the on-error triggers pass on any errors they don't deal with so the form can raise any necessary exceptions.
2. Make sure your exception handlers in the form's PL/SQL do the right thing. For example, a poor exception handler would be "exception when others then null;". This exception will eat important error messages.
3. Try running the application with statistics (trace = true) turned on. Oracle will generate a trace file named <dbname>_<pid>.trc. Use 'tkprof' to convert the trace file into a readable text file (sort SQL statements in the order of execution). Look through the trace file for any rollback statements or any other problems in the code.

There are other things that can cause this problem, but the above items should help you get started.

-- 
===============================================================
Richard Bennett		E-Mail: richhb_at_sequent.com
				73501.1703_at_compuserve.com
Computer People Inc.	On contract to Sequent Computer Systems