ERROR:
I found that error in application log and Database alert log when hitting the login URL.
Error in executing triggers on connect internal
*** 2017-01-21 18:37:11.364
----- Error Stack Dump -----
ORA-00604: error occurred at recursive SQL level 1
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at line 5
Solutions:
column TRIGGER_BODY format a1000
set pagesize 1000
spool trg.txt
SQL>select OWNER, TRIGGER_NAME,
TRIGGER_TYPE, TRIGGERING_EVENT, STATUS, TRIGGER_BODY
from DBA_TRIGGERS
where trim(triggering_event) = 'LOGON';
Status: Enabled
SQL>alter trigger LOGON_AUDIT_TRIGGER disable;
After disable the trigger Login page is opening.
I found that error in application log and Database alert log when hitting the login URL.
Error in executing triggers on connect internal
*** 2017-01-21 18:37:11.364
----- Error Stack Dump -----
ORA-00604: error occurred at recursive SQL level 1
ORA-01438: value larger than specified precision allowed for this column
ORA-06512: at line 5
Solutions:
column TRIGGER_BODY format a1000
set pagesize 1000
spool trg.txt
SQL>select OWNER, TRIGGER_NAME,
TRIGGER_TYPE, TRIGGERING_EVENT, STATUS, TRIGGER_BODY
from DBA_TRIGGERS
where trim(triggering_event) = 'LOGON';
Status: Enabled
SQL>alter trigger LOGON_AUDIT_TRIGGER disable;
After disable the trigger Login page is opening.
No comments:
Post a Comment