-
Saving current env in sqlplus scripts
In my sqlplus (version 10.2.0.3) scripts I want to save the current environment (ie, SETs, ALTER SESSIONs altered values, COLUMNs, BREAKs and COMPUTEs) before the execution of the scripts (because some scripts need to change it), and restore exactly then env after the execution : today I´m doing the SETs saving with a :
STORE set sqlplus_settings.sql REPLACE
in the beginning of the script, and a :
@sqlplus_settings.sql
in the end - what would be your suggestions for the rest of the points ??
Myself, I was thinking about of :
SPOOL sess_status.sql
BREAK
COMPUTE
COLUMN
SPOOL off
but the generated .sql file contains line breaks in the commands - I could to use something foreign to sqlplus to eliminate the breaks, but I prefer work in sqlplus, only. And I can´t use UTL_FILE (PL/SQL) for it, because the scripts can be running in the server OR in a client machine. Any suggestions are welcome...
Regards,
Chiappa
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
|