Re: Passing SQL*Plus bind variables to host command

On 2005-05-02, sameergn_at_gmail.com <sameergn_at_gmail.com> wrote:
> Hi,
>
> I tried this and it did not work
>
> SQL> var dirName varchar2(50);
> SQL> exec :dirName := 'newdir'
>
> PL/SQL procedure successfully completed.
>
> SQL> host mkdir :dirName
>
> SQL> host ls -ld newdir :dirName
> newdir: No such file or directory
> drwxr-xr-x 2 sanaik cisco 96 May 2 16:47 :dirName
>
> SQL>
>
> It created the directory names :dirName and not the newdir.
> Is it possible to pass bind variables to host command?

SQL> define dirname='newdir'
SQL> host mkdir &dirname
SQL> host ls &dirname

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/