Re: Data disappearing

Steven Deneir wrote >>
> The application has a certain part in which users can enter data
 concerning
> expenses that persons had to make to prepare a reunion. After each
 reunion,
> the persons that were present sign a paper and enter their hours of
 arrival
> and some other necessary information. Then a user enters all the
 information
> in the application, and launches some lists. After each month some global
> lists are made in order to do the payments. But at that time some of the
> data has disappeared.
>

I will leave reviewing your posted code to others or yourself, but I would like to suggest that you use the audit command of Oracle to record updates and deletes against the table that you said was only inserted to. This will allow you to discover if there is back door activity or other processes accessing the table while you continue to review the code.

I believe that the audit trail will tell you that 1) you have an application design code problem ( no hits) or 2) you have an access problem (records in audit trail) which probably means reviewing the code is a waste of time.

Good luck.   Received on Wed Mar 25 1998 - 00:00:00 CST