missing-replace-in-procedure (GN008)

Automatic fix is available.

What it does

Checks for replace in procedure creation.

Why not?

CREATE OR REPLACE PROCEDURE simplifies the process of modifying existing procedures, as you don't need to manually drop and recreate them.

If you drop and then recreate a procedure, the new procedure is not the same entity as the old; you will have to drop existing rules, views, triggers, etc. that refer to the old procedure. Use CREATE OR REPLACE PROCEDURE to change a procedure definition without breaking objects that refer to the procedure. It also maintains data integrity and consistency.

When should you?

If you don't need to modify an existing procedure.

Use instead:

CREATE OR REPLACE PROCEDURE.