The variable p_version is declared at the package level without the constant keyword:
p_version varchar2(50) := '0.0.1';
Because it is not defined as a constant, its value can be modified at runtime by any procedure or function within the package body. Version identifiers are typically intended to be immutable metadata. Allowing modification can lead to unintended changes, inconsistent version tracking, and maintenance issues.
The variable p_version is declared at the package level without the constant keyword:
p_version varchar2(50) := '0.0.1';Because it is not defined as a constant, its value can be modified at runtime by any procedure or function within the package body. Version identifiers are typically intended to be immutable metadata. Allowing modification can lead to unintended changes, inconsistent version tracking, and maintenance issues.