Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Which PRAGMA to use? "Func. does not guarantee not to update db"
Gilberto Inácio wrote:
>
> Simon Taylor wrote:
> >
> > Can anyone comment on this:
> >
> > When I call a plsql function from sqlplus (in a select statement), and the
> > function is part of a PL/SQL package, I get the following error:
> >
> > ORA-06571: Function F_GET_SCCN_ID does not guarantee not to update database
> >
> > Which translates to:
> >
> > 06571, 00000, "Function %s does not guarantee not to update database"
> > // *Cause: A plsql function that does not have a pragma asserting that it
> > // does not write any database state is referenced in a sql
> > statement.
> > // Such functions cannot be used in sql statements.
>
> I have the same problem, please send me the solution too.
> I really need the answer.
>
> PLEASE HELP!!!!
> --
>
> Thanks in advance, Inacio
>
try this one:
PRAGMA RESTRICT_REFERENCES (function_name, WNDS);
-- Joe Rogers Intelligent Information Systems, Inc. joer_at_renewal-iis.comReceived on Fri Jan 17 1997 - 00:00:00 CST