sameergn_at_gmail.com wrote in
news:1115078085.366791.172670_at_l41g2000cwc.googlegroups.com:
> 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?
>
No. What makes you think that the OS knows anything about "bind variables"?
Besides WHY do you want to issue an "ls" command.
SQL*Plus can't see the results of it.
Received on Mon May 02 2005 - 21:12:54 CDT
