云数据库 GaussDB-CREATE PROCEDURE:语法格式

时间:2025-02-12 15:08:27

语法格式

CREATE [ OR REPLACE ] PROCEDURE procedure_name    [ ( {[ argname ] [ argmode ] argtype [ { DEFAULT | := | = } expression ]}[,...]) ]    [       { IMMUTABLE | STABLE | VOLATILE }       | { SHIPPABLE | NOT SHIPPABLE }       | {PACKAGE}       | [ NOT ] LEAKPROOF       | { CALLED ON NULL INPUT | RETURNS NULL ON NULL INPUT | STRICT }       | {[ EXTERNAL ] SECURITY INVOKER | [ EXTERNAL ] SECURITY DEFINER | AUTHID DEFINER | AUTHID CURRENT_USER}       | COST execution_cost       | SET configuration_parameter { TO value | = value | FROM CURRENT }    ][ ... ] { IS | AS } plsql_body /
support.huaweicloud.com/centralized-devg-v2-gaussdb/gaussdb_42_0415.html