Path: news.easynews.com!easynews!ps01-sjc1!newsfeeds-atl2!news.webusenet.com!news03.bloor.is.net.cable.rogers.com!news01.bloor.is.net.cable.rogers.com.POSTED!not-for-mail
From: "Paul Quenneville" <paulq_nospam@rogers.com>
Newsgroups: comp.databases.oracle.tools
References: <ais6pr$j69@nntpb.cb.lucent.com>
Subject: Re: How to pass parameter with space
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.3018.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300
Message-ID: <wwh49.61010$wh1.24983@news01.bloor.is.net.cable.rogers.com>
Date: Wed, 07 Aug 2002 22:52:12 GMT
NNTP-Posting-Host: 24.156.42.193
X-Complaints-To: abuse@rogers.com
X-Trace: news01.bloor.is.net.cable.rogers.com 1028760732 24.156.42.193 (Wed, 07 Aug 2002 18:52:12 EDT)
NNTP-Posting-Date: Wed, 07 Aug 2002 18:52:12 EDT
Xref: easynews comp.databases.oracle.tools:52893
X-Received-Date: Wed, 07 Aug 2002 15:49:22 MST (news.easynews.com)

enclose your parameter within double quotes

"Yelu Zhou" <yellow@lucent.com> wrote in message
news:ais6pr$j69@nntpb.cb.lucent.com...
> We are running oracle 8i on solaris.  We need pass substitution parameter
to
> sqlplus. Tha parameter contains a space.  Could you help us.
> Thank you very much.
>
>