Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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:
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
![]() |
![]() |