Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

spool file error

800528Oct 26 2012 — edited Oct 27 2012
hi

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
This post has been answered by vijayrsehgal-Oracle on Oct 26 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 24 2012
Added on Oct 26 2012
17 comments
2,893 views