Help Center > > Developer Guide> Stored Procedures> Stored Procedure

Stored Procedure

Updated at: Sep 17, 2021 GMT+08:00

In GaussDB(DWS), business rules and logics are saved as stored procedures.

A stored procedure is a combination of SQL, PL/SQL, and Java statements, enabling business rule code to be moved from applications to databases and used by multiple programs at a time.

For details about how to create and invoke a stored procedure, see section "CREATE PROCEDURE" in SQL Syntax.

The functions and stored procedures created by using PL/pgSQL in PL/Java Functions are applicable to all the following sections.

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