Re: Pragma definition for PL/SQL Packages

nbhuvana_at_hotmail.com wrote:
>
> Hi !
> I tried to call a overloaded function in a PL/SQL package
> as user defined function in a sql statement
> and got the error ORA-06571 which says that 'Write No Database State'(WNDS)
> is not defined. Can someone help me with regard to defining the pragma
> when the function is overloaded. When the function was swapped it
> worked meaning the first definition only has the pragma definition.
>
> Thanks
> Bhuvana
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

I followed each of the functions declarations with its own pragma statement (even though it was the same statement in each case), e.g.

	FUNCTION func1(arg1 IN VARCHAR2, arg2 IN NUMBER) RETURN NUMBER;
	PRAGMA RESTRICT_REFERENCES(func1, WNDS, WNPS);
	FUNCTION func1(arg1 IN NUMBER, arg2 IN NUMBER) RETURN NUMBER;
	PRAGMA RESTRICT_REFERENCES(func1, WNDS, WNPS);

-- 

Mark Rothstein
xxxmarkr_at_snet.net
Remove 'xxx' to reply.