SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

After Logon Trigger

804056Oct 12 2010 — edited Oct 18 2010

I am currently writting a trigger to execute after users logon to the database to display last successful logon and the number of failed logon attempts since last successful logon. This is being written to run on 11.2.0.1 database. The problem I have encountered, how do I display the information back to the user, regardless of tool being used (SQLPLUS, TOAD, etc)? The use of dbms_output does not work since the user must set serveroutput on. Should it be displayed as raising an event? Are there other options?

Brian

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 15 2010

Added on Oct 12 2010

#11g, #database, #pl-sql

5 comments

511 views