Re: trigger from signing on?

From: Rainer Herbst <rherbst__at__rz.uni-potsdam.de>
Date: Fri, 20 Jun 2003 10:28:22 +0200
Message-ID: <3EF2C5A6.9080806@_rz.uni-potsdam.de>

see below

Regards!
Rainer Herbst

SPIDERMAN wrote:
> 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.
>

Connection handling is different for web applications. A connection might be established everytime a servlet is called, or, with connection pooling, even before the servlet is called ... Further, often for connecting a web application to the RDBMS, the application has an own schema/user account in the db, which will be different from your users login to the application. You could not rely on logon triggers in the case of a web application!

> "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 Fri Jun 20 2003 - 03:28:22 CDT