Re: SRW package

SRW package is specific to Oracle Reports -- has nothing to do with V$SQLAREA. Oracle Reports is not a good tools for an automatically refreshing screen.

You could use a time in Oracle Forms to automatically refresh a query based on V$SQLAREA (or any tables/views)

Or, if you are using mod_plsql for a web-based interface, you could incorporate a JavaScript timer in your generated code to refresh the page (or frame) containing the query results.

Bottom line, use a timer function appropriate to your UI tool.

• mcs

"Jumma" <juma_gandhi_at_yahoo.com> wrote in message news:c9ade84.0406070525.374391fa_at_posting.google.com...
| hi
|
|
|
| Earlier, I posted the following question :
|
| I am looking for a solution that would continuously show the contents
| of v$SQLArea.
| I am using version 8.1.7
|
| With regards to my above question, does SRW package give me the
| solution what I wanted?
| If so, Could someone give me the solution/suggestion about it?
|
| Thanks
|
| Jumma
Received on Mon Jun 07 2004 - 10:07:22 CDT