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
Messages: 11
Registered: May 2008
Location: UK
Junior Member

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:


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
Messages: 21151
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: Iconic Buttons
Next Topic: Installing Fonts / Copy a file to Windows Directory
Goto Forum:

Current Time: Thu Aug 24 00:09:12 CDT 2017

Total time taken to generate the page: 0.10371 seconds