Re: sql*plus and passing args with blanc spaces

it's working under windows environment with single quotes

c:\orawin95\bin\plus33w scott/tiger @script 'par1withoutspaces' 'par 1 with spaces'

In Unix environment, you must \ the quotes

# sqlplus scott/tiger @script \'par1withoutspaces\' \'par 1 with spaces\'

Have fun
FreD

Miguel De Buf <Miguel.DeBuf_at_orionsoftware.uunethost.be> wrote in article <3830205A.A8A12419_at_orionsoftware.uunethost.be>...
> 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:27:40 CST