Results 1 to 9 of 9

Thread: SQLPLUS Output

  1. #1
    Join Date
    Oct 2009
    Posts
    3

    Unanswered: SQLPLUS Output

    Hello...

    I am trying to run a script that calls sqlplus and executes a sql script...

    so in side my script, i am calling

    sqlplus user/pass@sid @sqlscript.sql

    that works fine, but the issue is that
    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP and Data Mining options

    is always displayed before and after the output... i know if i spool the output i can get around this, but that doesn't work in the scenario I have.

    Any way to remove those messages?

  2. #2
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Why don't you use the -silent option?

    http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch4.htm#1006198

  3. #3
    Join Date
    Oct 2009
    Posts
    3
    Perfect...

  4. #4
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    I always wonder why people don't read the manual before posting a question...

  5. #5
    Join Date
    Oct 2009
    Posts
    3
    Whats a manual?

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Quote Originally Posted by bjamin82
    Whats a manual?
    You don't even need to Read The Fine Manual.

    Code:
    sqlplus -help
    
    SQL*Plus: Release 10.2.0.4.0 - Production
    
    Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
    
    Usage 1: sqlplus -H | -V
    
        -H		   Displays the SQL*Plus version and the
    		   usage help.
        -V		   Displays the SQL*Plus version.
    
    Usage 2: sqlplus [ [<option>] [<logon>] [<start>] ]
    
      <option> is: [-C <version>] [-L] [-M "<options>"] [-R <level>] [-S]
    
        -C <version>   Sets the compatibility of affected commands to the
    		   version specified by <version>.  The version has
    		   the form "x.y[.z]".	For example, -C 10.2.0
        -L		   Attempts to log on just once, instead of
    		   reprompting on error.
        -M "<options>" Sets automatic HTML markup of output.  The options
    		   have the form:
    		   HTML [ON|OFF] [HEAD text] [BODY text] [TABLE text]
    		   [ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]
        -R <level>	   Sets restricted mode to disable SQL*Plus commands
    		   that interact with the file system.	The level can
    		   be 1, 2 or 3.  The most restrictive is -R 3 which
    		   disables all user commands interacting with the
    		   file system.
        -S		   Sets silent mode which suppresses the display of
    		   the SQL*Plus banner, prompts, and echoing of
    		   commands.
    
      <logon> is: (<username>[/<password>][@<connect_identifier>] | /)
    	      [AS SYSDBA | AS SYSOPER] | /NOLOG
    
        Specifies the database account username, password and connect
        identifier for the database connection.  Without a connect
        identifier, SQL*Plus connects to the default database.
    
        The AS SYSDBA and AS SYSOPER options are database administration
        privileges.
    
        The /NOLOG option starts SQL*Plus without connecting to a
        database.
    
      <start> is: @<URL>|<filename>[.<ext>] [<parameter> ...]
    
        Runs the specified SQL*Plus script from a web server (URL) or the
        local file system (filename.ext) with specified parameters that
        will be assigned to substitution variables in the script.
    
    When SQL*Plus starts, and after CONNECT commands, the site profile
    (e.g. $ORACLE_HOME/sqlplus/admin/glogin.sql) and the user profile
    (e.g. login.sql in the working directory) are run.  The files may
    contain SQL*Plus commands.
    
    Refer to the SQL*Plus User's Guide and Reference for more information.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Quote Originally Posted by bjamin82
    Whats a manual?
    It's a book about a Spanish guy named Manual. You should read it.

  8. #8
    Join Date
    Nov 2003
    Posts
    2,933
    Provided Answers: 12
    Quote Originally Posted by bjamin82
    Whats a manual?
    Didn't you read the link I posted?

  9. #9
    Join Date
    Oct 2002
    Location
    Baghdad, Iraq
    Posts
    697
    Quote Originally Posted by shammat
    Didn't you read the link I posted?
    Could you repost the link you posted? I just don't feel like scrolling.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •