Xref: alice comp.databases.oracle.tools:35382
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!tank.news.pipex.net!pipex!uunet!zur.uu.net!ffx.uu.net!news-feed.netvision.net.il!194.90.1.15.MISMATCH!news!not-for-mail
From: "Gilad A." <gilade@rafael.co.il>
Newsgroups: comp.databases.oracle.tools
Subject: HOST Command under SQLPLUS
Date: Thu, 11 Nov 1999 10:19:13 +0200
Organization: NetVision Israel	
Lines: 28
Message-ID: <80dtl9$67v$1@news.netvision.net.il>
X-Trace: news.netvision.net.il 942307817 6399 207.232.43.144 (11 Nov 1999 08:10:17 GMT)
X-Complaints-To: abuse@netvision.net.il
NNTP-Posting-Date: 11 Nov 1999 08:10:17 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

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