Forum Stats

  • 3,837,993 Users
  • 2,262,316 Discussions
  • 7,900,462 Comments

Discussions

Issue with Azure Social Sign in

Simon Collins
Simon Collins Member Posts: 129 Bronze Badge

Hi All

We are on APEX 20.1 and are trying to get Authentication working with Azure. We are using generic Oauth2 provider method as described in the helpful articles found in the below link

https://fuzziebrain.com/content/id/1908/

It is working well for most users but for some we get failures seemingly because the token that Azure is sending back is too long for APEX to cope with. The snippet of a debug is shown below.

This seems similar to an earlier bug in APEX 18 noted below

https://support.oracle.com/knowledge/Middleware/2451220_1.html

Can anyone suggest any practical workarounds for this?

encrypted the token value. len=4011


1.697670.00051Exception in "final_exception_handler":
Error Stack: ORA-01461: can bind a LONG value only for insert into a LONG column
Backtrace: ORA-06512: at "APEX_200100.WWV_FLOW_CREDENTIAL", line 514
ORA-06512: at "APEX_200100.WWV_FLOW_CREDENTIAL", line 551
ORA-06512: at "APEX_200100.WWV_FLOW_AUTHENTICATION_SOCIAL", line 414
ORA-06512: at "APEX_200100.WWV_FLOW_AUTHENTICATION_SOCIAL", line 488
ORA-06512: at "APEX_200100.WWV_FLOW_AUTHENTICATION_NATIVE", line 429
ORA-06512: at "APEX_200100.WWV_FLOW_AUTHENTICATION_NATIVE", line 1262
ORA-06512: at "APEX_200100.WWV_FLOW_PLUGIN", line 3042
ORA-06512: at "APEX_200100.WWV_FLOW_PLUGIN", line 3202
ORA-06512: at "APEX_200100.WWV_FLOW_AUTHENTICATION", line 1652
ORA-06512: at "APEX_200100.WWV_FLOW", line 2485

Thanks

Simon

Tagged: