DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SQL Script

  1. #1
    Join Date
    Feb 2002
    Posts
    14

    Question

    Hi,

    I am trying to generate SQL Script with a logginng facility. When i set the SPOOL option and execute the script using SQL Plus, the SPOOL file contains "TABLE CREATED", but i want " TABLE CREATED".
    I tried to add remarks, but they are also not coming into Spooled file. Is there any SQL Plus command or header/environment setting, throught which i can ad the details to the spooled file.

    Secondly, in the SQL Script file, is there any way i can abort execution in between, when error occurs.

    Please help me

    Jagannadh

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Hi,
    use the PROMPT command to add your comments to output.
    You can abort a script with the WHENEVER SQLERROR command.
    More to both of the commands (and many more) you can find here:
    http://otn.oracle.com/docs/products/...h8.htm#1010735

    Ales

  3. Posting Permissions

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


    Click Here to Expand Forum to Full Width