ob_enable_parameter_anonymous_block

Description

ob_enable_parameter_anonymous_block specifies whether to enable parameterization for anonymous blocks in the current session.

Limitations

• Query the variable

  • Global-level operation

    In the sys tenant or a user tenant, you can execute the SHOW VARIABLES statement to query the variable at the global level or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (in Oracle mode) for the variable at the global level.

  • Session-level operation

    In the sys tenant or a user tenant, you can execute the SHOW VARIABLES statement to query the variable at the session level or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (in Oracle mode) for the variable at the session level.

• Modify the variable

  • Global-level operation

    • In the sys tenant, you can directly change the value of the variable at the global level.

    • In OceanBase Database V4.2.0 and later V4.x versions, you must have the ALTER SYSTEM privilege to change the value of the variable at the global level in an Oracle user tenant.

  • Session-level operation

    In the sys tenant or a user tenant, you can directly change the value of the variable at the session level for the current tenant.

Attributes

Considerations

You can use the ob_enable_parameter_anonymous_block variable to specify whether to enable parameterization for anonymous blocks.

Examples

• Session-level operation

  obclient> SET ob_enable_parameter_anonymous_block = off;
  

• Global-level operation

  obclient> SET GLOBAL ob_enable_parameter_anonymous_block = on;