Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Passing SQL*Plus bind variables to host command

Passing SQL*Plus bind variables to host command

From: <sameergn_at_gmail.com>
Date: 2 May 2005 16:54:45 -0700
Message-ID: <1115078085.366791.172670@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?

Thanks,
Sameer Received on Mon May 02 2005 - 18:54:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US