PROCEDURE prc_blah( period IN NUMBER)
IF ( period = daily ) THEN
/* Do stuff */
Is there a way to define a alphanumeric constant that does not introduce package state and therefore the possibility of "ORA-04068: existing state of packages has been discarded" occurring if the package is changed? It is a lot nicer to read ( period = daily ) than ( period = 0 ) but not at the cost of having to handle ORA-4068.