max_sp_recursion_depth

Description

max_sp_recursion_depth specifies the maximum number of recursive calls to any specified stored procedure.

Privilege requirements

• Query variables

  • Global level

    sys tenant and all user tenants can use the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) and the information_schema.GLOBAL_VARIABLES view (MySQL mode) to view the values of Global system variables.

  • Session level

    sys tenant and all user tenants can use the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) and the information_schema.SESSION_VARIABLES view (MySQL mode) to view the values of Session system variables.

• Modify variables

  • Global level

    • sys tenant can directly modify the value of Global system variables.

    • MySQL user tenants need to have the SUPER or ALTER SYSTEM privilege to modify the value of Global system variables.

    • Oracle user tenants need to have the ALTER SYSTEM privilege to modify the value of Global system variables.

  • Session level

    sys tenant and all user tenants can directly modify the value of Session system variables for their own tenant.

Attributes

Examples

Set the current stored procedure to not be recursively called.

• Session level

  obclient> SET max_sp_recursion_depth =0;
  

• Global level

  obclient> SET GLOBAL max_sp_recursion_depth =0;