Re: Pragma definition for PL/SQL Packages

In article <6e6s2i$vtp$1_at_nnrp1.dejanews.com>,   Bhovana.Natarajan_at_Unilever.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
>

Bhuvana
I found that I had to put my function in a package before I could use the WNDS pragma...

CREATE OR REPLACE PACKAGE YourPackage IS

    FUNCTION YourFunction (
      in_date IN DATE)
    RETURN DATE;

• Assert that the function does not update any databas

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Mar 13 1998 - 00:00:00 CST