spool file error
800528Oct 26 2012 — edited Oct 27 2012hi
I have a requirement that
i have a sql file in location and take output sql file put to another file as dat in aonther location .
these all have to be done in .sqlfile(and register as concurrent program) i had thought before register concurrent program the sql
try it on sql*plus .
hard coding.
declare
fl_path varchar2(100):='D:\venkateswaran works\DBA\file generator\new programs'
f_name varchar2(200) := 'testvenky'
o_path varchar2(100) := 'D:\venkateswaran works\DBA\file generator\new programs'
o_name varchar2(100) := 'testvenky.dat'
begin
spool $o_path$o_name;
@$fl_path$f_name;
spool off;
exception
when others then
dbms_output.put_line('error');
end;
it is show error .
iam using windows for path
and oracle 10g sql*plus.
please help me in regard