Re: sql*plus and passing args with blanc spaces

The shell interpreter suppresses the double quote and then pass the result to sqlplus.
To avoid this, use both double quote and single quote like this :

  sqlplus scott/tiger @script.sql "par1withoutspaces" " 'par 1 with spaces' "

(I've added one space between ' and " just for readability ...)

Pierre

Miguel De Buf wrote :

> Hi there,
>
> I try to run sql*plus scripts and pass it arguments with spaces, but it
> does not seem to work :
>
> # sqlplus scott/tiger @ script.sql "par1withoutspaces" "par 1 with
> spaces"
>
> sqlplus seems to recognise the second parameter as 4 different
> parameters. How can I make sql*plus see this second parameter as only
> one parameter with whitespaces ?
>
> Anyone knows the answer ?
>
> Please email to Miguel.DeBuf_at_orionsoftware.uunethost.be
>
> Thanks a lot,
>
> Miguel
Received on Mon Nov 15 1999 - 10:17:32 CST