ALTER SESSION SET CURRENT_SCHEMA = APEX_040000;

BEGIN

APEX_INSTANCE_ADMIN.SET_PARAMETER('REQUIRE_HTTPS', 'N');

commit;

end;

/*

sourced from:

https://docs.oracle.com/database/121/AEADM/adm_mg_service_set.htm#CIHBJDHH

*/