Home » SQL & PL/SQL » SQL & PL/SQL » screen messages
screen messages [message #36881] Mon, 31 December 2001 03:44 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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

----------------------------------------------------------------------
Previous Topic: Default value in Array
Next Topic: Problem with explicit cursor
Goto Forum:
  


Current Time: Mon Aug 03 05:13:19 CDT 2020