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 -> Re: pb calling oracle function

Re: pb calling oracle function

From: Oliver Willandsen <oliver.willandsen_at_sg.cec.be>
Date: Thu, 03 Jun 1999 16:37:27 GMT
Message-ID: <7j6b05$jlg$1@nnrp1.deja.com>


In article <37568F1D.17268B1C_at_perinfo.com>,   Christophe LUCET <clucet_at_perinfo.com> wrote:
> Hello!
> I created a function that call a stored procedure which takes a string
> for inout parameters.
> This function aims to print the string parameter after execution of
the
> stored procedure.
> But when i call the function by :
> select fn_testerfx from sys.dual;
> Oracle answers to me :
> ORA-06571: something like "FN_TESTERFX can't be sure not to change
datas
> in the database....
> Thanks for all answers that can help me.
> Bye
> :-)
>
>

Christophe,

here's straight from the manual

There are two possible causes for this message:

Action: If the referenced function is a packaged PL/SQL function: Recreate the PL/SQL function with the required pragma; be certain to include the 'Write No Database State' (WNDS) argument in the argument list of the pragma.

If the referenced function is a stand-alone PL/SQL function: Do not use the function!

HTH
--
Oliver Willandsen - [European Commission - http://europa.eu.int]

All comments represent my own opinion and may not in any circumstance be regarded as stating an official position of the European Commission

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 03 1999 - 11:37:27 CDT

Original text of this message

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