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

Galen Boyer <galenboyer_at_hotpop.com> wrote:

>On Tue, 10 Aug 2004, john.g_at_dot.spamfree.com wrote:
>> Galen Boyer <galenboyer_at_hotpop.com> wrote:
>>
>>>On Tue, 10 Aug 2004, john.g_at_dot.spamfree.com wrote:
>>>> "Anurag Varma" <avdbi_at_hotmail.com> wrote:
>>>> SqlPlus -S does suppress the Connected ( an all other
>>>> prompts( using WXP, in DOS box - works the same with
>>>> Sqlplusw.exe -S in Window)
>>>> ------------------------------------------------------------------------------------------
>>>> c:\Downloads>sqlplus -S wmsreport/warehouse_at_whs1
>>>>
>>>> select * from dual;
>>>>
>>>> D - X
>>>> ----------------------------------------------------------------------------------------------------
>>>
>>>But, the following happens.
>>>
>>> > sqlplus -S galen/galen
>>> select 'A' from dual;
>>>
>>> '
>>> -
>>> A
>>>
>>> conn galen/galen
>>> Connected.
>>> select 'A' from dual;
>>>
>>> '
>>> -
>>> A
>>>
>>>From what I read, this "connected" is what the OP is looking to
>>>remove.
>>
>>
>> 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 - 12:50:36 CDT