var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Error Log
Is there any way for me to create a log file when I run a script for any errors or the results?
The problem is that I have a very very long script and it gives quite a few errors but once it passes through the SQL Window or the script is done running, I can scroll up and see the errors.
I use this command to run my script :
Re: Error Log
SQL> SPOOL myoutput.txt
SQL> @c:\upgrade.sql [/SIZE][/QUOTE]
SQL> SPOOL OFF
Thanks for that...
Will it complain if my script also has some stuff that it spools?
What does this statements do?
Yes, you can only be spooling to one file at a time. If the script contains a SPOOL command then spooling to the original file is turned off.
[/SIZE][/QUOTE] is just some DBForums formatting I accidentally copied - please ignore!
This is my script
select 'create user ' || sysadm.OA0P0990.USERID || ' identified by ' || sysadm.OA0P0990.USERID ||
' default tablespace users temporary tablespace temp account unlock; ' from sysadm.OA0P0990;
select 'GRANT RESOURCE TO ' || sysadm.OA0P0990.USERID || ';' from sysadm.OA0P0990;
select 'GRANT CONNECT TO ' || sysadm.OA0P0990.USERID || ';' from sysadm.OA0P0990;
How can I get a commit statement inbetween each select to get spooled?