'Hi!,

I need suppress the "Conectado" (connect) message which is displayed
when I use the CONN command in SQL*Plus.

I tried with FEEDBACK, ECHO, PAGESIZE..... etc. Is there any way to
"connected" message not to be displayed.

Thanks a lot.

P.D.: Sorry for my english! :-)

"Juan Carlos Pe?uela" <jcpenuela (AT) supercable (DOT) es> schrieb im Newsbeitrag news:7345dcbf.0402250419.68f1f139 (AT) posting (DOT) google.com...
sqlplus -S ... suppresses all output. Might be too quiet for you.

Lots of Greetings!
Volker

"Juan Carlos Pe?uela" <jcpenuela (AT) supercable (DOT) es> wrote

if you want to suppress if from displaying on the screen (or to piped
output), use SET TERMOUT OFF. ie:

reconnect.sql script:
-----------------------------
set termout off
connect &1
set termout on
set heading off
set pause off
select
'Currently connect as '
set heading on

-----------------------------

SQL> @reconnect scott/tiger

Currently connect as SCOTT at DEV01.US.ORACLE.COM

SQL> @reconnect bad/credentials
SP2-0640: Not connected

(of course, it sounds like you would not want any validation message at all,
so just leave out the SELECT ... FROM GLOBAL_NAME)


if you want to 'suppress' it from a spool file, don't open the spool file
until you issue the connect


does this cover your scenarios?

;-{ mcs