Re: sql*plus and passing args with blanc spaces

From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Mon, 15 Nov 1999 15:32:25 GMT
Message-ID: <01bf2f8e$38de0880$a504fa80@mndnet>

Hi,

Could you use accept command ?

Here it is, I have put the accept and prompt commands in a script named x1.sql :

accept answer char prompt 'Enter Name: ' prompt &answer

SURESH_at_MGSP>@x1
Enter Name: Suresh N. Bhat
Suresh N. Bhat
SURESH_at_MGSP> Suresh Bhat
Oracleguru
www.oracleguru.net

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 - 09:32:25 CST