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

From: Galen Boyer <galenboyer_at_hotpop.com>
Date: 10 Aug 2004 11:49:11 -0500
Message-ID: <ullgney9n.fsf@standardandpoors.com>

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.

-- 
Galen Boyer

Received on Tue Aug 10 2004 - 11:49:11 CDT