Who Can Alter a Package
The ALTER PACKAGE
statement can be executed by:
-
The owner of the package
-
Users with the
ALTER ANY PACKAGE
privilege
The ALTER PACKAGE
statement can be executed by:
The owner of the package
Users with the ALTER ANY PACKAGE
privilege
ALTER PACKAGE
ALTER PACKAGE APP_VAR
AS
BEGIN
FUNCTION GET_DATEBEGIN() RETURNS DATE DETERMINISTIC;
FUNCTION GET_DATEEND() RETURNS DATE DETERMINISTIC;
PROCEDURE SET_DATERANGE(ADATEBEGIN DATE,
ADATEEND DATE DEFAULT CURRENT_DATE);
END