ob_enable_ps_parameter_anonymous_block

Description

ob_enable_ps_parameter_anonymous_block specifies whether to enable parameterization of anonymous blocks and call statements in the parse stage in the PL/SQL mode.

Privilege requirements

• Query variables

  • Global level

    sys and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) or information_schema.GLOBAL_VARIABLES view (MySQL mode) to obtain the values of global system variables.

  • Session level

    sys and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) or information_schema.SESSION_VARIABLES view (MySQL mode) to obtain the values of session system variables.

• Modify variables

  • Global level

    • sys tenants can directly modify the values of global system variables.

    • MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the values of global system variables.

    • Oracle user tenants must have the ALTER SYSTEM privilege to modify the values of global system variables.

  • Session level

    sys and all user tenants can directly modify the values of session system variables.

Attributes

Examples

Enable parameterization of anonymous blocks and call statements in the parse stage in the PL/SQL mode.

• Global level

obclient> SET GLOBAL aob_enable_ps_parameter_anonymous_block=ON;

• Session level

obclient> SET ob_enable_ps_parameter_anonymous_block=ON;