Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Passing SQL*Plus bind variables to host command
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?
Thanks,
Sameer
Received on Mon May 02 2005 - 18:54:45 CDT
![]() |
![]() |