Creating a Stored Procedure

Scenarios

A stored procedure consists of a set of SQL statements that can complete specific tasks or process complex services. This section describes how to create a stored procedure. You can use loop statements in a stored procedure to insert objects repeatedly.

Prerequisites

• You have obtained the CREATE ROUTINE permission.
• You have obtained the Execute permission.

Procedure

1. On the top menu bar, choose Database Management. On the displayed Objects page, select Stored Procedures, and click Create Stored Procedure.
2. On the displayed page, enter the stored procedure name and description, and click OK.
3. On the displayed page, click Option, set the required parameters, and click OK. Then, save and execute the stored procedure.
4. View the execution status in the Message area.