ORA-30553: The function is not deterministic Cause: The function on whichthe index is defined is not deterministic Action: If the function isdeterministic, mark it DETERMINISTIC. If it is not
deterministic (it depends on package state, database state, current time, or 18-71
anything other thanthe function inputs) then do not create the index. The values
returned by a deterministic function should not change even when the functionis
rewritten or recompiled.