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
Date: 1997/06/04
Message-ID: <MPG.dffc43c6c29613a989683_at_news.acay.com.au>#1/1
PL/SQL: I've declared a function in a package that simply
returns a constant.
When I use this function in a SQL query I get an error
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