<budget_name>!REMOVE_CYCLE_START_ACTION

Removes the user-defined action that is triggered when the budget cycle restarts.

See also:

<budget_name>!SET_CYCLE_START_ACTION, <budget_name>!GET_CYCLE_START_ACTION

Syntax

<budget_name>!REMOVE_CYCLE_START_ACTION()
Copy

Returns

Returns a VARCHAR value indicating whether the cycle start action was successfully removed.

Access control requirements

The following privileges and roles are required to call this method for a budget:

  • ADMIN instance role for the budget instance.

  • USAGE privilege on the database and schema that contain the budget instance.

For more information, see Budgets roles and privileges.

Usage notes

Calling this method does not return the object. Because of this, you can’t use method chaining to call another method on the return value of this method. Instead, call each method in a separate SQL statement.

Examples

Remove the cycle-start action from budget my_budget in schema budget_db.sch1:

CALL budget_db.sch1.my_budget!REMOVE_CYCLE_START_ACTION();
Copy
Language: English