Posted By: Bernhard S host cmd window executed asynchronously - 09/25/12 04:47 PM
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.
We'll try to enhance this.
I would like to second this request. I posted on Stack Overflow this issue as well.
© Allround Automations forums