Xref: alice comp.databases.oracle.misc:46837 comp.databases.oracle.server:73993 comp.databases.oracle.tools:35622
Path: alice!news-feed.fnsi.net!netnews.com!newspeer.monmouth.com!newsfeed2.news.nl.uu.net!sun4nl!EU.net!news0.Belgium.EU.net!newsr.Belgium.EU.net!not-for-mail
From: Miguel De Buf <Miguel.DeBuf@orionsoftware.uunethost.be>
Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.misc,comp.databases.oracle.server
Subject: sql*plus and passing args with blanc spaces
Date: Mon, 15 Nov 1999 16:01:46 +0100
Organization: EUnet Belgium, Leuven, Belgium
Lines: 22
Message-ID: <3830205A.A8A12419@orionsoftware.uunethost.be>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 4.07 [en] (X11; I; Linux 2.0.36 i686)

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@orionsoftware.uunethost.be

Thanks a lot,

Miguel