Home » Developer & Programmer » Forms » exit_Form hanging (Oracle Forms 10g)
exit_Form hanging [message #338646] Tue, 05 August 2008 09:35 Go to next message
matspring
Messages: 11
Registered: May 2008
Location: UK
Junior Member
Hi

Can you help?

I have form A which Calls Form B - does a whole load of SQL Loader processing before returning to form A using the exit_form command. Accept it hangs continuously.........!

Debugging has identified that

a) the :system.mode is NORMAL when the exit_form command runs
b) the code in form A that follows the call to form B does not run
c) any code added after the exit_form command does not run
d) I have added occasional SYNCHRONIZE command in form B to let the screen 'catch up' with the processing, this works but slows the process down
e) I can confirm that all SQL loader processing completes successfully

the exact call is:

call_form('UTIF1001', NO_HIDE, NO_REPLACE, no_query_only, pl_id);

the exact exit is:

exit_form;

This is seriously doing my head in, any help appreciated
Re: exit_Form hanging [message #338688 is a reply to message #338646] Tue, 05 August 2008 11:47 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Form B is used to load data using SQL*Loader. Is there additional computing which might take a long time, so EXIT_FORM just "waits" until processing is finished?

Did you try to use EXIT_FORM(NO_VALIDATE) (if possible) so that it, perhaps, doesn't have to "think" whether something has changed, if so what it was, possibly rollback changes etc.?
Previous Topic: How to get display item name at the run time in form 6i
Next Topic: Send pdf in mail attachment
Goto Forum:
  


Current Time: Sat Dec 10 16:22:53 CST 2016

Total time taken to generate the page: 0.17375 seconds