Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Munich, Germany
    Posts
    35

    Unanswered: SQLPlus over the command line

    Hello,

    I am having some trouble with the SQLPlus tool over the command line.

    Here is what I do:

    on the command line I give the command:
    sqlplus /nolog @c:\mycommands.sql

    The mycommands.sql file contains:

    CONNECT sys/syspass@mydatabase as sysdba
    spool c:\output.txt
    Select * from some_table
    spool off
    exit

    However, the command line only shows the message connected and does not exit. The spool file also contains no information. I want it to execute the command and quit SQLPlus.

    I hope someone can help me.

    Thanks,
    Pankaj

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    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.

  3. #3
    Join Date
    Jan 2004
    Location
    Munich, Germany
    Posts
    35

    Found it!

    I did not know you needed semi colons at the end of each command.

    Pankaj

Posting Permissions

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