Running in SQL*Developer, connected as SYSTEM.
APEX version 4.2.1.00.08.
Is this a bug or something I'm doing wrong?
When I try use apex_instance_admin.set parameter to set the instance EMAIL_INSTANCE_URL parameter, I get the following error.
Error starting at line : 13 in command -
BEGIN
apex_instance_admin.set_parameter
('EMAIL_INSTANCE_URL','http://ah9.appshosting.com:7780/pls/apex/');
end;
Error report -
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 356
ORA-06512: at "SYS.HTP", line 1368
ORA-06512: at "SYS.HTP", line 1443
ORA-06512: at "SYS.HTP", line 1735
ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 154
ORA-20987: Instance parameter not found
ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 613
ORA-06512: at "APEX_040200.WWV_FLOW_ERROR", line 903
ORA-06512: at "APEX_040200.WWV_FLOW_INSTANCE_ADMIN", line 215
ORA-06512: at line 2
06502. 00000 - "PL/SQL: numeric or value error%s"
*Cause:
*Action:
Getting the parameter is no problem:
select apex_instance_admin.get_parameter
('EMAIL_INSTANCE_URL') instance_email_url
FROM dual;
INSTANCE_EMAIL_URL
http://ah9.appshappy.com:7780/pls/apex/
Getting and setting a few other parameters works fine.
Skip