Re: pb calling oracle function

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:

• A SQL statement references a packaged PL/SQL function that does not contain a pragma that prevents the database from being updated.
• A SQL statement references a stand-alone, PL/SQL function that contains an instruction to update the database.

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