| screen messages [message #36881] |
Mon, 31 December 2001 03:44  |
vidya v
Messages: 4
Registered: December 2001
|
Junior Member |
|
|
How do I capture messages that oracle throws after the completion of an SQL command?
For eg: The create table command results in a "table created" message on the screen. How do I manipulate this message so as to use it to my advantage, for instance, direct it to a notepad????
thanks in advance
vidya
----------------------------------------------------------------------
|
|
|
|
| Re: screen messages [message #36887 is a reply to message #36881] |
Mon, 31 December 2001 07:37  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
spool to text file .
SQL> spool xyz.log
SQL> create table xyz(n number);
Table Created.
SQL> spool off
----------------------------------------------------------------------
|
|
|
|
| Re: screen messages [message #36891 is a reply to message #36881] |
Tue, 01 January 2002 19:58 |
vidya v
Messages: 4
Registered: December 2001
|
Junior Member |
|
|
Hi suresh!
Thank you for the suggestion.
There is one more thing I would like to know....
The spooling is probably carried out by accessing a system file or table where the screen display gets stored.
Is this file or table maintained by oracle or by the underlying OS???
Is it possible to access this file or table directly rather than thru spooling???
thank you
vidya
----------------------------------------------------------------------
|
|
|
|
| Re: screen messages [message #36897 is a reply to message #36881] |
Wed, 02 January 2002 02:49 |
vidya v
Messages: 4
Registered: December 2001
|
Junior Member |
|
|
There is one more thing that I would like to know...is it possible to append to a spool file?
thanks in advance
vidya
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
