-
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
-
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
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
|
|