login failed due to ORA-06502

below errors displayed when use sqlplus to login database.

SQL> conn informatica_abc_efgh@test
Enter password:
ERROR:
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 10


However some user can login from the same machine. and the same user can login from database server locally and from some other windows laptop.

the cause is implementation of an afterlogin trigger. when you set up afterlogin trigger, be careful for set the variable size.