Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Cannot call function in query

Cannot call function in query

From: Rowan McCammon <rowanm_at_intercoast.com.au>
Date: 1997/06/04
Message-ID: <MPG.dffc43c6c29613a989683@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 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US