Topic Options
#44641 - 09/25/12 12:47 PM host cmd window executed asynchronously
Bernhard S Offline

Registered: 09/15/04
Posts: 305
Loc: Munich, Germany
I'm calling within a command window an SQL*Loader via SQL*Plus host command:
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.

#44645 - 09/26/12 07:20 AM Re: host cmd window executed asynchronously [Re: Bernhard S]
Marco Kalter Administrator Offline

Registered: 08/30/99
Posts: 16912
We'll try to enhance this.
Marco Kalter
Allround Automations

#47264 - 06/10/13 07:00 PM Re: host cmd window executed asynchronously [Re: Bernhard S]
Clever Idea Consulting Offline

Registered: 02/21/06
Posts: 14
Loc: Plano, Texas USA
I would like to second this request. I posted on Stack Overflow this issue as well.


Moderator:  support