Re: Forms: PC locks up during PL/SQL process

Using dummy table is fine but not with a database trigger. The form will wait for the triggers to complete before returning process to the form. Instead pass all form data to a dummy database table. In this example, I will use a unix system.

1. Create a backround task on the unix system which runs every ???? minutes(or hours) which processes all the rows from this table.
2. There is also an Oracle package called DBMS_ALERT which you might be able to trigger a procedure to start after you put the data in the dummy table.

Feel free to contact me at my address. Received on Sat Oct 12 1996 - 00:00:00 CEST