Host Command Under SQLPLUS

From: Ofer Zuntz <oferzu_at_rafael.co.il>
Date: Thu, 11 Nov 1999 10:15:54 +0200
Message-ID: <382A7B3A.937ABFE7@rafael.co.il>

Hi ,

I try to write in sqlplus :

---

declare
  l_source varchar2(30) ;
  l_target  varchar2(30) ;
 
 Begin
   l_source := 'xxxxxxx' ;
   l_target  := 'yyyyyyy' ;

end;
/
host cp -p  <source_file>   < target_file>

exit

---

I want that the source_file/target file  will be l_source/l_target  (so I can do a dynamic copy) .
The main problem who pass a sqlplus variable to the host command.

Any help  ??
Regards ,
Ofer
 
 
 

---

Name        : Ofer Zuntz
Company     : Gav System Ltd
Profession  : Computer consulting,planning & programming
Address     : P.o.b  7361 Haifa Zip 31074 Israel
Phone Home  : (972)  4-8247334
Phone Work  : (972)  4-8794035
Mobile      : (972)  54-824733
E-mail      : oferzu_at_rafael.co.il;
---------------------------------------------------------

 
Received on Thu Nov 11 1999 - 02:15:54 CST