| exit_Form hanging [message #338646] |
Tue, 05 August 2008 09:35  |
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  |
 |
Littlefoot
Messages: 21823
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.?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
