Re: SQL*Plus - Hide "Connected" response to Connect

Galen is right, I connect to one schema in the script and then to another within the same script.

And, by the way, I resemble that remark about the "real OS" by Hans, a few messages back. ;-)

+Les

"Turkbear" <john.g_at_dot.spamfree.com> wrote in message news:cl2ih01egtvoe9gmt8f53bgou7rpopnjkp_at_4ax.com...
> Galen Boyer <galenboyer_at_hotpop.com> wrote:
>

<SNIP>

> >>
> >> Using the Connect ( or conn) from within an existing SqlPlus
> >> session is NOT the same as using Sqlplus -S, which is what the
> >> OP asked about..
> >>
> >> I do not believe that there is a connect -S option..
> >
> >Here is what the OP said:
> >
> > ,----
> > | When spooling the output of a SQL*Plus SELECT statement, if
> > | I connect to a different schema, the "Connected" response
> > | goes into the spool file. I've tried setting everything
> > | OFF that I can find but can't get rid of it. Can anyone
> > | help?
> > `----
> >
> >I read that to say that he had already connected and then, within
> >that same script, connects to a different schema. Oh well, maybe
> >the OP can help out.
>
> OK, I had only part of the OP's thread - the part that stated:
> > Thanks, Hans and Ana. Yes, I did search the manual first, and found
> >> > > nothing.
> >> > >
> >> > > SQLPLUS -S doesn't suppress the "Connected" response.
> >> > >
>
> Thanks..
Received on Tue Aug 10 2004 - 22:07:36 CDT