Thank you for your reply. Sorry I wasn't being clearer. The client wants to
approach the web-based application from the current VB6 application, so yes,
I think that's where we are heading, perhaps toward Java centric apps. I
know I can use servlet to connect to Oracle then make a query then fire the
necessary alert, but I am exploring the options now. If the connection is
made via a web application, how would you do it from what you discussed?
steps by steps instructions are greatly appreciated. Thank you.
"Ethel Aardvark" <bigjobbies_at_hotmail.com> wrote in message
news:1a8fec49.0306190423.310aaf49_at_posting.google.com...
> You might want to look at Schema-Level Triggers (in 8i+). These can
> fire during logon/logoff.
> However, unless I misunderstand your requirements, you will not be
> able to do what you want. How are the connections to be made?
> SQL*Plus? A management console? A web application? A custom server
> application? They will all fire the trigger and run it OK on the
> database but how on earth is the server going to handle all these
> different types of client application?
>
> You could consider a custom application which checks for certain
> events, or possibly even a wrapper for SQL*Plus.
>
> Good luck!
>
> ETA
>
> "SPIDERMAN" <consultant2b_at_hotmail.com> wrote in message
news:<uvbIa.293465$3n5.22571_at_news2.central.cox.net>...
> > I don't know much about Oracle (except for the PL?SQL), so please bear
with
> > me. I was just wondering if there was a way to create an alert
triggered by
> > user signing on? I want to create an alert as a pop up dialog box (java
> > function call?) that list the names of the people having birthdays
(names
> > and DOB's stored in a table) the following day. Can I make this as a
trigger
> > based on the fact that some table is automatically modified when user
sign
> > on? If so, what is the name of this table? What are the steps I need to
> > accomplish this? Any inputs are greatly appreciated.
Received on Thu Jun 19 2003 - 08:00:51 CDT
