Hi,
This is a copy of a dead thread that is a few years old.
I have a simple script which I'm trying to execute from SQL Developer, my plan is to add this to a button on the login page once working.
I am on Apex 18.1.0.00.45
declare
v_workspace number;
BEGIN
sELECT MAX(workspace_id)
INTO v_workspace
FROM apex_applications
WHERE application_id = 103;
wwv_flow_api.set_security_group_id(v_workspace);
APEX_UTIL.RESET_PW(
p_user => '******_*******',
p_msg => 'Your password has been reset by administrator.');
END;
The error that I'm getting is.
Error report -
ORA-20001: Package variable g_security_group_id must be set.
ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1808
ORA-06512: at "APEX_180100.WWV_FLOW_API", line 1843
ORA-06512: at "APEX_180100.WWV_FLOW_FND_USER_INT", line 2700
ORA-06512: at "APEX_180100.HTMLDB_UTIL", line 1537
ORA-06512: at line 15