I am in apex.oracle.com . Trying to create a custom authentication .
When I login with correct password, it works fine. However If I enter a wrong password, instead of going to the login page and display the failure message, it shows some checksum error.
I checked various postings on web, and tried different setups. No success
Can anyone please help.
This is not locally installed, This is on apex.oracle.com trial workspace version 5.0
Here is the detail
- is_internal_error: true
- apex_error_code: APEX.NOTIFICATION_MSG.CHECKSUM_CONTENT_ERROR
- component.type: APEX_APPLICATION_PAGES
- component.id: 70731000000101
- error_backtrace: ----- PL/SQL Call Stack ----- object line object handle number name 0x49785b860 641 package body APEX_050000.WWV_FLOW_ERROR 0x49785b860 709 package body APEX_050000.WWV_FLOW_ERROR 0x49785b860 1013 package body APEX_050000.WWV_FLOW_ERROR 0x49aed7ea0 1082 package body APEX_050000.WWV_FLOW_SECURITY 0x49aed7ea0 1099 package body APEX_050000.WWV_FLOW_SECURITY 0x497ab6138 4273 package body APEX_050000.WWV_FLOW 0x4977e7308 173 procedure APEX_050000.F 0x325c2e5f8 2 anonymous block
********************************************************************
.
The custom authentication has only two functions
create or replace FUNCTION obfuscate(text_in IN VARCHAR2) RETURN RAW IS
l_returnvalue RAW(16);
BEGIN
--dbms_obfuscation_toolkit.md5(input => utl_raw.cast_to_raw(text_in), checksum => l_returnvalue);
l_returnvalue := dbms_obfuscation_toolkit.md5(input => utl_raw.cast_to_raw(text_in));
RETURN l_returnvalue;
END obfuscate;
/*************************************************************************************************************/
create or replace FUNCTION authenticate(p_username IN VARCHAR2
,p_password IN VARCHAR2) RETURN BOOLEAN IS
l_obfuscated_password RAW(16);
l_value NUMBER;
l_username VARCHAR2(100) := p_username;
l_password VARCHAR2(100) := p_password;
l_return BOOLEAN;
BEGIN
l_obfuscated_password := obfuscate(text_in => l_password);
BEGIN
SELECT 1
INTO l_value
FROM socmis_users a
WHERE 1 = 1
AND upper(a.user_name) = upper(l_username)
AND a.password = l_obfuscated_password;
EXCEPTION
WHEN no_data_found
OR too_many_rows THEN
l_value := 0;
WHEN OTHERS THEN
l_value := 0;
END;
IF l_value = 1 THEN
l_return := TRUE;
ELSE
l_return := FALSE;
END IF;
RETURN l_return;
END authenticate;
Following is the URL I get when the error comes. The error comes only when I enter wrong password
https://apex.oracle.com/pls/apex/f?p=70731:101:0:::::¬ification_msg=Invalid%20Login%20Credentials%3Cdiv%20id=%2522ape…
Update
**********************
I noticed that This is happening with one particular application only , and the error is coming even with Oracle_application_express Accounts standard authentication . Not just custom
Only happen, when a wrong password is entered.
The application is actually created when apex.oracle.com was in 4.2 . When oracle upgraded to 5.0 it automatically upgraded.
Can someone please help. I am stuck
George
Message was edited by: gkthomas