Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL Newbie Question
On 8 May 2005 12:49:18 -0700, "Ed_Zep" <ed_zep_at_ntlworld.com> wrote:
>I was going to set up a table and have the PL/SQL procedure update it
>but I know nothing about PL/SQL and was wondering if anyone could tell
>me a way of doing this?
Look up the AUDIT facility in the Oracle Rdbms admin manual. Enable audit by setting dba_audit_trail to db and run AUDIT CONNECT. The info you require will now be stored in DBA_AUDIT_SESSION.
Evidently, this has nothing to do with PL/SQL
-- Sybrand Bakker, Senior Oracle DBAReceived on Sun May 08 2005 - 15:18:46 CDT