Can I stop SQL*Plus from displaying "connected" when I have a "connect" in a script?

Posted by René Nyffenegger on Stack Overflow See other posts from Stack Overflow or by René Nyffenegger
Published on 2010-03-18T09:47:11Z Indexed on 2010/03/18 9:51 UTC
Read the original article Hit count: 161

Filed under:

Oracle

|

sqlplus

I have a few sql scripts that I need to run via SQL*Plus. These scripts connect several times as different users with a connect user_01/pass_01@db_01. Now, each time the script does such a connect, it confirms the successful connection with a connected. This is distracting and I want to turn it off.

I can achieve what I want with a

set termout off
connect user_01/pass_01@db_01
set termout on

Is there a more elegant solution to my problem?

Note, it doesn't help to permanently set termout off at the start of the script since I need to know if a command didn't run successfully.

© Stack Overflow or respective owner

Related posts about Oracle

E-Business Suite Technology Sessions at OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Oracle OpenWorld 2012 is almost here! We're looking forward to updating you on our products, strategy, and roadmaps. This year, the E-Business Suite Applications Technology Group (ATG) will participate in 25 speaker sessions, two Meet the Experts round-table discussions, five demoground booths and… >>> More
26 Days: Countdown to Oracle OpenWorld 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Welcome to our countdown to Oracle OpenWorld! Oracle OpenWorld 2012 is just around the corner. In less than 26 days, San Francisco will be invaded by an expected 50,000 people from all over the world. Here on the Oracle WebCenter team, we’ve all been working to help make the experience a great… >>> More
OTN ???? ?????? ???????

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Database ?? Database ??????? Database ?????????? Java WebLogic Server/????????·???? SOA/BPM/????? ???????/???? ID??/?????? ?????EPM/BI EPM/BI ??????? EPM/BI ???? OS/??? ???? ????? MySQL Database ?? ???? ?? ????????? ??? ?? ORACLE MASTER… >>> More
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012

as seen on Oracle Blogs - Search for 'Oracle Blogs'
SOA PARTNER COMMUNITY NEWSLETTER JULY 2012 Dear SOA partner community member To provide our community members the best of our knowledge, we want your feedback on our SOA Partner community. Thus we are organizing SOA Partner Community Survey 2012. We… >>> More
Oracle ADF Coverage at OOW

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Below is the schedule for all ADF related sessions at a glance. Note the Meet and greet session added for Wednesday Octiber 3rd from 4.30 pm to 5:30. Oracle ADF and Fusion Development General Session Mon 1 Oct,… >>> More

Related posts about sqlplus

Starting SQLPlus in linux

as seen on Server Fault - Search for 'Server Fault'
How do you start sqlplus in linux? I know this is a service in windows. >>> More
SQLPlus - spooling to multiple files from PL/SQL blocks

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a query that returns a lot of data into a CSV file. So much, in fact, that Excel can't open it - there are too many rows. Is there a way to control spool to spool to a new file everytime 65000 rows have been processed? Ideally, I'd like to have my output in files named in sequence, such as… >>> More
Running pl/sql in Korn Shell(AIX)

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a file to execute in Ksh written by someone. It has a set of commands to execute in sqlplus. It starts with, sqlplus -s $UP <<- END followed by a set of ddl commands such as create,drop,etc., When I execute the file in the shell, I get the error in the starting line quoted above… >>> More
Oracle SQLPlus: How to display the output of a sqlplus command without having to first issue the spo

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to display the output of a sqlplus command without having to first issue the spool off command? I am spooling the results of a sqlplus session to a file while at the same time tailing the file. The reason for this is that for table with very long rows the format is easier to look… >>> More
Broker vs. SQLPLUS to manage Data Guard configuration

as seen on Server Fault - Search for 'Server Fault'
Hi all, Can anyone tell me the link to the comparison between using SQLPLUS and Data Guard Broker to manage data guard configuration? Advantages and disadvantages of those two command line interfaces? Thanks, Sarith >>> More