Hi,
Somehow one of users managed to achieve following during LOGIN to APEX application:
additional_info : ORA-28817: PL/SQL function returned an error.
display_location : ON_ERROR_PAGE
is_internal_error: true
apex_error_code : APEX.UNHANDLED_ERROR
ora_sqlcode : -28817
ora_sqlerrm : ORA-28817: PL/SQL function returned an error.
error_backtrace :
ORA-06512: at "SYS.DBMS_CRYPTO_FFI", line 67
ORA-06512: at "SYS.DBMS_CRYPTO", line 44
ORA-06512: at "APEX_050100.WWV_FLOW_CRYPTO", line 197
ORA-06512: at "APEX_050100.WWV_FLOW_SECURITY", line 2538
ORA-06512: at "APEX_050100.WWV_FLOW_SECURITY", line 3051
ORA-06512: at "APEX_050100.WWV_FLOW", line 3025
ORA-06512: at "APEX_050100.WWV_FLOW", line 5533
Error was reported by our custom error reporting function (application level). According to support.oracle.com this means that suggests incorrect use of dbms_crypto (Doc ID 956603.1). It looks like bug in APEX code unless I am missing something.
DBMS version: 12.1.0.2.0
APEX version: 5.1
Using custom authentication.
Unfortunately, even if error function did catch the problem I am not able to reproduce it at the moment.
Ideas welcome.
Thanks in advance
Sincerely
Maris