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: Successful login via SQLPlus produces a server error

Re: Successful login via SQLPlus produces a server error

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 27 Apr 2005 09:39:52 +0200
Message-ID: <d4nfk8$8h1$1@news.BelWue.DE>


g3000 wrote:
> I found that there is one on longon trigger named ' SYS_LOGON ' there
> is a call to logon_proc. In the text for that proc ( which is wrapped )
> I do see DBMS_SESSION with a colon behind it.
>
> SQL> select trigger_body from dba_triggers where
> trigger_name='SYS_LOGON';
>
> TRIGGER_BODY
> --------------------------------------------------------------------------------
> logon_proc;
>
> SQL> select trigger_body from dba_triggers where
> trigger_name='SYS_LOGOFF';
>
> TRIGGER_BODY
> --------------------------------------------------------------------------------
> logoff_proc(lt.getSid);
>
> SQL> select text from user_source where name='LOGON_PROC' and
> type='PROCEDURE';
>
> TEXT
> --------------------------------------------------------------------------------
> procedure logon_proc wrapped
> 0
> abcd
> <snipped>
>
> Makes me wonder if this is where it comes from.
>

Then comment it out, for god's sake! Easiest thing to do I should think.

Cheers,
Holger Received on Wed Apr 27 2005 - 02:39:52 CDT

Original text of this message

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