** This thread discusses the article: TechTip: Simplify Stored Procedure Upgrades with Parameter Defaults **
I experimented using this today and discovered a couple of things:
1. My procedure source is set up to Create or Replace the procedure. If you add extra parameters and execute this the system creates a new procedure with the different signature. This can be avoided by specifying the specific name of the procedure (which is typically the same as the name of the procedure) using keyword specific after the external keyword section.
I experimented using this today and discovered a couple of things:
1. My procedure source is set up to Create or Replace the procedure. If you add extra parameters and execute this the system creates a new procedure with the different signature. This can be avoided by specifying the specific name of the procedure (which is typically the same as the name of the procedure) using keyword specific after the external keyword section.