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.
>
> DA Morgan here are the query results:
> SQL> select object_name from dba_objects where object_name LIKE
> 'V%SQL%';
>
> OBJECT_NAME
> --------------------------------------------------------------------------------
> V_$SQL
> V_$SQLAREA
> V_$SQLTEXT
> V_$SQLTEXT_WITH_NEWLINES
> V_$SQLXS
> V_$SQL_BIND_DATA
> V_$SQL_BIND_METADATA
> V_$SQL_CURSOR
> V_$SQL_PLAN
> V_$SQL_PLAN_STATISTICS
> V_$SQL_PLAN_STATISTICS_ALL
>
> OBJECT_NAME
> --------------------------------------------------------------------------------
> V_$SQL_REDIRECTION
> V_$SQL_SHARED_CURSOR
> V_$SQL_SHARED_MEMORY
> V_$SQL_WORKAREA
> V_$SQL_WORKAREA_ACTIVE
> V_$SQL_WORKAREA_HISTOGRAM
> V$SQL
> V$SQLAREA
> V$SQLTEXT
> V$SQLTEXT_WITH_NEWLINES
> V$SQLXS
>
> OBJECT_NAME
> --------------------------------------------------------------------------------
> V$SQL_BIND_DATA
> V$SQL_BIND_METADATA
> V$SQL_CURSOR
> V$SQL_PLAN
> V$SQL_PLAN_STATISTICS
> V$SQL_PLAN_STATISTICS_ALL
> V$SQL_REDIRECTION
> V$SQL_SHARED_CURSOR
> V$SQL_SHARED_MEMORY
> V$SQL_WORKAREA
> V$SQL_WORKAREA_ACTIVE
>
> OBJECT_NAME
> --------------------------------------------------------------------------------
> V$SQL_WORKAREA_HISTOGRAM
>
> 34 rows selected.
>
> SQL>
I knew what magic views were there. What you need to do is use them to look inside and see what is executing. The SQL statement was just a hint of where to look.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)