Reading text files on MS-DOS

In my previous entry, I was trying to process a text files (a CSV), using each line of that file as input for my SQL*Plus call.
But, what happens if you don't have a UNIX box where you can execute it??? :(
Let's write my shell script into a batch file (oh man!), and this is the result: @echo off for /f "tokens=1,2,3,4 delims=," %%a in (./input/dummy_shipped_orders.txt) do ( sqlplus CIDB/CIDB1234@CIDB @report.sql %%a %%b %%c %%d ) Where %%a is the first token, %%b the second one, and so on (until we'd reached the fourth token - as specified on tokens=1,2,3,4)
At the end, it was simple :D

Report in SQLPlus using spool to write a file

On my previous entry I'm reading a file and using each line as input to make an external call (call SQL*Plus for example) Well, this is my SQL (script) to be executed using SQL*Plus, in other words, I will execute this query for each line of a given file (shell script), each time that I call SQLPlus I'll append to the spool (output file) the result of my query (I'll pass as parameter to my query the parameter given on command call)

sqlplus CIDB/CIDB1234@CIDB @input_file.sql PRE11221000001

And this is my Query (my report, because I'm adding more stuff)
SET TERMOUT OFF SET SPACE 3 SET LINESIZE 500 SET NUMWIDTH 15 SET PAGESIZE 80 SET FEEDBACK OFF SET VERIFY OFF SET UNDERLINE = SET TRIMSPOOL ON ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS'; column date_column new_value today_var SELECT TO_CHAR(SYSDATE,'yyyy-mm-dd') date_column FROM DUAL; SPOOL output_file_&today_var APPEND; SELECT cust_id, acct_num, pos_order_id, pos_loc_cd, total_order_lines, order_state, order_state_date, cidb_order_id, add_lines_cnt, upg_lines_cnt, eqp_lines_cnt, pos_pre_order_id FROM CUST_ACCT_ORDER WHERE pos_pre_order_id = '&&1'; SPOOL off; EXIT;

&&1

is the first parameter after the script namde in command line, then the second param will be &&2 then the third one &&3 and so on

My output will be a file named: output_file_2011-02-04.LST

For more information and references please see the official Oracle web site for SQL*Plus:
Ref 1
Ref 2
Ref 3
Ref 4

Run a SQLPlus script and pass a parameter as input

Simple:
call sqlplus user/password@database @your_script.sql abc123 qwe890 <br />
Then your script:
begin dbms_output.put_line(&&1);
dbms_output.put_line(&&2);
end;
/