Home » SQL & PL/SQL » SQL & PL/SQL » Spool a report file in the Background
Spool a report file in the Background [message #317558] Thu, 01 May 2008 23:05 Go to next message
jack_chessire
Messages: 5
Registered: April 2008
Junior Member
Is there a way to spool a file without the user seeing it?

I'm in a situation where, whenever I update a row in one of the tables I have, I'd like for a new report file to be generated to reflect said change.

However, I don't want the user to see the report being generated. is there a way to do this?
Re: Spool a report file in the Background [message #317559 is a reply to message #317558] Thu, 01 May 2008 23:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW posting guidelines as stated above
Re: Spool a report file in the Background [message #317565 is a reply to message #317558] Thu, 01 May 2008 23:52 Go to previous messageGo to next message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
SET TERMOUT OFF (link is for 10gR2)

In further cases, please primarily consult SQL*Plus User's Guide and Reference, which is part of the documentation, found eg. online on http://tahiti.oracle.com/.
Re: Spool a report file in the Background [message #317727 is a reply to message #317558] Fri, 02 May 2008 16:11 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What do you plan to do with all these reports? View them one by one? Wouldn't you rather consider some other kind of auditing? If not "true" auditing, perhaps a simple "history" table populated by a database trigger; you could then view contents of this table and see what was happening in a much simpler manner than searching through bunch of report files (by the way, if your operating system doesn't allow versioning, new report version might overwrite the old one unless you add some kind of a unique identifier (timestamp, sequence, ...) to a report name).
Previous Topic: Rewrite my MSSQL procedure to Oracle syntax
Next Topic: PLS-00103: Encountered the symbol "NUMBER" when expecting one of the following: := .
Goto Forum:
  


Current Time: Tue Feb 11 14:41:32 CST 2025