Re: problem accessing Standard package

It looks like a problem with the 'purity level'. Oracle has no guarentee that this function won't update the database. What you'll probably need to do is put the function in a package, where the package spec script is something like this:

create or replace PACKAGE My_Package
as

    FUNCTION My_Function RETURN Varchar2;     PRAGMA RESTRICT_REFERENCES (My_Function, WNDS[, RNDS | , WNPS | , RNPS);

the only one you'll really need is WNDS - Writes No Database State but you will need to put them in a package to do the Restrict_References bit

Jim

Martin Simoneau <msimoneau_at_iname.com> wrote in message news:ob2k3.7006$8v6.448258_at_carnaval.risq.qc.ca...
> In article <WN%j3.6779$8v6.444765_at_carnaval.risq.qc.ca> , "Martin Simoneau"
> <msimoneau_at_iname.com> wrote:
>
> > When I'm trying to use DBMS_OUTPUT.PUT_LINE function from my function
and I
> > received the following error message:
> >
> > ORA­06571 function name does not guarantee not to update database.
> >
> > In fact, when I'm trying to access functions/procs/packages from outside
my
> > schema I receive the ORA­06571 message.
> >
> > Thanks in advance!
> >
> >
> > Martin
> >
> >
> I was accessing the function from a select ( select FIND_EXPR('data') from
> mytable). I have try to access the function from a procedure and
everything
> is working fine!
>
>
>
Received on Sun Jul 18 1999 - 17:12:38 CDT