Q: Forms 4 - PL/SQL Trigger Execution

HELP !! I have a form that executes a host shell script that runs a SQL script to produce a report on KEY-COMMIT.

The problem is that the report takes a while to run and I would like to inform the user that it is running when they commit the form, currently it just sits there until the report has finished.

I have tried a :-

   MESSAGE ('Running Report - Please Wait ...');

statement before the host call in the KEY-COMMIT Trigger, but as far as I can see FORMS has to process the whole PL/SQL block (including Host call) before writing to the screen as the message appears when the host call has finished !

Can anyone HELP ?

-- 
Robbie Hancock
Database Development Engineer
Motorola ECID,                        
16 Euro Way,        Tel No +44 793 545368
Blagrove, Swindon,  Fax No +44 793 541228    
England, SN5 8YQ.   E-mail hancockr_at_zeus.swindon.rtsg.mot.com

"Rude alert! Rude alert! An electrical fire has knocked out my voice
recognition unicycle! Many Wurlitzers are missing from my database! Abandon
shop! This is not a daffodil! Repeat: This is not a daffodil!" Holly