Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ON-LOGON Trigger ??

Re: ON-LOGON Trigger ??

From: Robert Bralic <robo_bralic_at_yahoo.co.uk>
Date: Thu, 28 Jul 2005 08:27:02 +0200
Message-ID: <dc9trp$l4s$2@ss405.t-com.hr>

<fitzjarrell_at_cox.net> wrote in message
news:1122468689.416115.169070_at_z14g2000cwz.googlegroups.com...
>
>
> Robert Bralic wrote:
> > Hallo,
> >
> > I would likre to write in PL/SQL small tool for
> > dba-s,that will note from "V$SESSION" for any,
> > login username and other datas into a table,
> > something like "last" on UNIX, but I don't know
> > how to write and compile this function with that
> > trigger(ON-LOGIN, if this exysts), so I need
> > a little help.
> >
> >
> > Thanks in advance, Robert !
> > robert.bralic_at_si.t-com.hr
>
>
> It has been done before, and such code is available in "Oracle9i:
> PL/SQL Programming", by Scott Urman. You can download the code he's
> written here:
>
> http://shop.osborne.com/cgi-bin/oraclepress/downloads.html
>
> LogPkg1.sql and LogPkg2.sql are what you need to use. Stop trying to
> re-invent the wheel.
>
>
> David Fitzjarrell
>

Dear,

I'am sory for my question but internet is sometimes to big, and in my company they don't by me books, and I 'am not well payed.Somethimes when I have a free time is to boring, and I make of some small, and usable software just for kill a boringes...

                                        Thanks, Robert..!!
Received on Thu Jul 28 2005 - 01:27:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US