This content has been marked as final. Show 3 replies
You don't mention your version or OS - so can't give an answer for sure.
I use dbms_output.put_line in my sqlplus programs, the results come out on the output file of the concurrent request.
Since dbms_output.put_line does not produce output until the process completes, I don't know that this would be help monitoring, but could give information after program completes.
Our version from /etc/redhat-release is: Red Hat Enterprise Linux Server release 5.7 (Tikanga).
Shell scripts are very hard to develop and maintain. Many things that developers previously had to do in shell scripts, developers can now do in PL/SQL. Hence, I recommend that you avoid shell scripts as much as possible.
As well, SQL*Loader is an old, inflexible tool. Instead, define your OS file as an external table, and then extract from the external table using a normal select statement. http://www.orafaq.com/node/848 I recommend that you avoid SQL*Loader and use external tables instead.
Using PL/SQL and external tables - and avoiding the shell script and SQL*Loader - a much better way to accomplish the same thing all inside one packaged procedure that is registered as a concurrent program:
- select from the external table
- manipulate the data