Trigger not getting user name after SERVERERROR

[Unna]

Thanks for your advice. I changed the code to:

CREATE OR REPLACE TRIGGER test
after servererror on database
declare
pragma autonomous_transaction;
BEGIN
If (ORA_IS_SERVERERROR(1017)) Then
insert into test_tb values (user, ora_login_user, SYS_CONTEXT ('USERENV', 'OS_USER') , '-1017', userenv('terminal'), sysdate);
commit;
End If;
End;
/

But the user and ora_login_user fields are still not capturing anything or I miss something? Any advice?


Thanks,
Unna