SRW package

[Jumma]

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

[Mark C. Stock]

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_...@yahoo.com> wrote in message
news:c9ade84.04060...@posting.google.com...

[Jumma]

Hi Mark,

Thanks for your information.
I will appreciate if you send me some little example of timer (forms)
with regards to my question.
I wanted that the contents of v$SQLArea continuously shown via forms
6i.

Thanks

Jumma

"Mark C. Stock" <mcstockX@Xenquery .com> wrote in message news:<auqdnfdtBq-...@comcast.com>...

[Mark C. Stock]

lookup the WHEN-TIME-EXPIRED trigger/event in the on-line help