Print Thread
host cmd window executed asynchronously
#44641 09/25/12 04:47 PM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
OP Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
I'm calling within a command window an SQL*Loader via SQL*Plus host command:
Code
host sqlldr user/password@tnsname ...
After that in my command window script I query the table I filled via SQL*Loader before and count the number of loaded rows there using
SQL Query
select count(*) from mytable;
However the host command is executed asynchronously, that means my load is still running while the count already returns 0 rows, because the load is not complete and committed yet at the point where my query starts already.
When I run my script in sql*plus in Windows or Unix the host cmd window executing sqlldr loads the data synchronously and the calling script won't be continued before the load is finished. I think this behaviour makes a lot more sense and I would expect PL/SQL Developer synchronously as well.


Regards,
Berny
Re: host cmd window executed asynchronously
Bernhard S #44645 09/26/12 11:20 AM
Joined: Aug 1999
Posts: 22,173
Member
Offline
Member
Joined: Aug 1999
Posts: 22,173
We'll try to enhance this.


Marco Kalter
Allround Automations
Re: host cmd window executed asynchronously
Bernhard S #47264 06/10/13 11:00 PM
Joined: Feb 2006
Posts: 14
Plano, Texas USA
C
Member
Offline
Member
C
Joined: Feb 2006
Posts: 14
Plano, Texas USA
I would like to second this request. I posted on Stack Overflow this issue as well.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.141s Queries: 15 (0.074s) Memory: 2.5037 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2024-03-28 20:08:18 UTC
Valid HTML 5 and Valid CSS