1. API Reference
  2. APEX_INSTANCE_ADMIN
  3. SET_PARAMETER Procedure

32.32 SET_PARAMETER Procedure

This procedure sets a parameter used in administering a runtime environment. You must issue a commit for the parameter change to take affect.

Syntax

APEX_INSTANCE_ADMIN.SET_PARAMETER (
    p_parameter     IN VARCHAR2,
    p_value         IN VARCHAR2 DEFAULT 'N',
    p_force         IN BOOLEAN  DEFAULT FALSE );

Parameters

Parameter Description
p_parameter The instance parameter to be set.
p_value

The value of the parameter.

See Available Parameter Values.

p_force

Default FALSE.

If TRUE, accepts the value even if it is missing some quality criteria. Basic data type validation occurs (such as numeric, Y/N) , but Oracle APEX accepts more values. For example, credentials can be SHA-1 and shorter than 2048 bit. ALLOW_HASH_FUNCTIONS parameter must also support SHA-1.

The parameter only applies for the parameters:

  • SAML_APEX_CERTIFICATE
  • SAML_APEX_CERTIFICATE2
  • SAML_IP_SIGNING_CERTIFICATE
  • SAML_IP_SIGNING_CERTIFICATE2

The parameter forces the storage of the certificate in case the quality check of the certificate raises an error.

Example

The following example demonstrates how to use the SET_PARAMETER procedure to set the SMTP_HOST_ADDRESS parameter for an Oracle APEX instance. 

BEGIN
    APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_HOST_ADDRESS', 'mail.example.com');
    COMMIT;
END;

Parent topic: APEX_INSTANCE_ADMIN