Cannot call function in query

From: Rowan McCammon <rowanm_at_intercoast.com.au>
Date: 1997/06/04
Message-ID: <MPG.dffc43c6c29613a989683_at_news.acay.com.au>#1/1


[Quoted] [Quoted] PL/SQL: I've declared a function in a package that simply [Quoted] returns a constant.

[Quoted] [Quoted] When I use this function in a SQL query I get an error [Quoted] message that tells me something like "Cannot perform query as database may be updated. Cannot guarantee nonupdate."

If I then define a copy of this function outside the package (i.e.. simply a stored function) and call it from within a query, the query works fine.

Can anyone explain this to me?

Any help appreciated,
Rowan McCammon. Received on Wed Jun 04 1997 - 00:00:00 CEST

Original text of this message