Job Seekers   Employers
dbapool: Authors | Submissions | Contact Us
   Forgot password? | Sign up
  Home   Discussion Forum   Articles   Interview Questions   FAQs   Scripts   Rewards   Analyzer   White Papers   Blog   Certification   Downloads   Tools
 

Topic: SQL*Plus and PL/SQL >> suppress sql*plus message

Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property. You may review the entire Oracle Certification Program Candidate Agreement online Here.



  


 Title: suppress sql*plus message
 Ravindra  Posted: Jan 05, 2006 12:28:03 PM

 Total Post: 60
 Joined: May, 2005






 HI
suppose you want to connect to a database using sql*plus:-
SQL> CONNECT SYSTEM/MANAGER@SERVICE_NAME
WILL TAKE YOU TO THE TARGET.

My question is whether any way is there to suppress the following error.
In the below statement the password is missing.

SQL> CONNECT SYSTEM/ @SERVICE_NAME
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]
where ::= [/][@] | /


Ravindra Nookala

 Ravindra
Posted: Jan 16, 2006 03:10:38 PM  

 Total Post: 60
 Joined: May, 2005






 
Hi

I already found the solution.

Ravi Nookala

 chandra
Posted: Jan 29, 2006 01:54:33 AM  

 Total Post: 2
 Joined: Jan, 2006






 
Can you please let us know the solution

Thanks
Shekar.

 Ravindra
Posted: Jan 31, 2006 02:39:38 PM  

 Total Post: 60
 Joined: May, 2005






 
on sql*plus commandline , you can not supress this .

If you are putting the code in an sql file.
set termout off
will supress the error.

Ravindra Nookala

 Time Zone: EDT

  




Forum Rules & Description


Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user




 








Get FREE Magazines

Top 10 Forum User

  Murtuja Khokhar857
  Mohammed Taj746
  positive fanatic483
  Jayanta Sur479
  Vigyan Kaushik386
  Vinoth Kumar367
  Gopu Gopi340
  Gitesh Trivedi322
  neeraj sharma258
  Ramesh Jois246






oracle Mag



  About Us Advertise Terms of Use Privacy Newsletters Contact Us    

Home   Discussion Forum   FAQs  Articles  Jobs   Newsletters  Directory  Downloads 

Our Premium Sponsor
Confio Software