标题: ORA-30553: The function is not deterministic [打印本页] 作者: admin 时间: 2016-9-4 21:40 标题: ORA-30553: The function is not deterministic 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.