HOST Command under SQLPLUS

From: Gilad A. <gilade_at_rafael.co.il>
Date: Thu, 11 Nov 1999 10:19:13 +0200
Message-ID: <80dtl9$67v$1_at_news.netvision.net.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 Received on Thu Nov 11 1999 - 09:19:13 CET