I think that you need to lookup Oracle's definition of deterministic. I
believe it's quite different than what the OED would say... :-)
"Antti Järvinen" <costello_at_iki.fi> wrote in message
news:m3hed8jy0c.fsf_at_muikku.baana.suomi.net...
> "Giovanni Azua" <bravegag_at_hotmail.com> writes:
> > saying I provided a non-deterministic function:
> >
> > CREATE INDEX PURCHASEKEY
> > ON PURCHASE_PRODUCT
> >
(FOGFC_GETPURCHASEKEY(PERSON_ID,BRANCH_ID,PRODUCT_ID,PURCHASE_DATE,SIZE_ID,C
> > OLOR_ID));
> >
> > The following error has occurred:
> > ORA-30553: The function is not deterministic
>
> What does deterministic mean? I don't have documentation handy right now
> and this determinism is odd concept to me.. does it mean 1:1 mapping
between
> input and output? I can see that not happening as you used to_char()
> function with date-type with format string that did omit time-part
> of the date, thus making all times of same day to produce same
> output.
>
> But if determinism is something else then I have no clue.
>
> --
> Antti Järvinen, costello_at_iki.fi
> "concerto for two faggots and orchestra"
Received on Fri Dec 20 2002 - 14:03:29 CST
