Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Successful login via SQLPlus produces a server error
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