17.24 SET_PARAMETER Procedure
The SET_PARAMETER
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');
Parameters
Table 17-22 SET_PARAMETER Parameters
Parameter | Description |
---|---|
|
The instance parameter to be set. |
|
The value of the parameter. See "Available Parameter Values". |
Example
The following example demonstrates how to use the SET_PARAMETER
procedure to set the SMTP_HOST_ADDRESS
parameter for an Oracle Application Express instance.
BEGIN
APEX_INSTANCE_ADMIN.SET_PARAMETER('SMTP_HOST_ADDRESS', 'mail.example.com');
COMMIT;
END;
Parent topic: APEX_INSTANCE_ADMIN