SQL & PL/SQL

Hi,

Oracle9i

How to execute the below procedure from windows batch script without calling separate .sql file?

This below mentioned oracle statements should be included in the batch file itself.


set serveroutput on
DECLARE
var1 varchar2;
var2 varchar2;
var3 varchar2;
var4 varchar2;
var5 varchar2;
var6 varchar2;
cur1;
BEGIN
Procedure_name(&var1,&var2,&var3);
LOOP
FETCH cur1 INTO var4,var5,var6;
EXIT WHEN cur1%NOTFOUND;
dbms_output.put_line(.................);
END LOOP;
END;


Also need to generate the separate log file of the procedure o/p

How it can be done ?

Regards