Richard,

Richard Mace schrieb:

> Hi,
>
> I know that there is a way of using ddl to "create or alter" a table,
> but it there a similar way of doing the same thing for stored
> procedures? Or do you just use create procedure and ignore any errors?

RECREATE PROCEDURE <proecure_name>
will DROP and CREATE the procedure.
Will fail if there are depenedencies.

CREATE OR ALTER PROCEDURE <proecure_name>
will create the procedure if it doesn't exits, otherwise will alter it.

Luc.