Help Center > > User Guide> GaussDB (for openGauss) DB Instance Management (Development Tool)> Database Management> Stored Procedure Management> Altering or Executing a Stored Procedure

Altering or Executing a Stored Procedure

Updated at: Jun 09, 2021 GMT+08:00


  1. On the top menu bar, choose Database Management. On the displayed Objects tab, choose Stored Procedures on the left, locate the target procedure, and click Alter or Execute in the Operation column.

    Figure 1 Stored procedure list

  2. On the displayed page, enter the required SQL statement and click Save.

    Figure 2 Altering or executing a stored procedure

  3. Click Execute to set the input parameters of the stored procedure.
  4. Ensure that the settings are correct and click Execute.

    Figure 3 Set Input Parameter

  5. After the SQL statement is executed, view the execution status on the Messages tab in the lower part of the page.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?

Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel