Nested SQLPlus
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Nested SQLPlus

  1. #1
    Join Date
    Mar 2007
    Posts
    2

    Nested SQLPlus

    I have a SQLPlus work script that spools a file. I call this in one of two ways, from a web based interface, or from another SQLPlus prompt routine. If I call from the web based, I need this work routine to exit when complete. If called from from SQLPlus routine, I need it to return to that same routine when complete. If I use EXIT/QUIT, it exits SQLPlus completely without returning, If I don't, it leaves SQLPlus open. Any ideas or is this a catch22??

    Thanks,

    RLiss

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Why don't you use a simple procedure?

  3. #3
    Join Date
    Mar 2007
    Posts
    2
    Explain?

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,445

    Cool


    For web-based, create another sql script to execute the first one, kind like this:
    Code:
    -- MyScript_Web.sql
    @MyScript
    exit



    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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