-
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
-
Why don't you use a simple procedure?
-
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|