NLS_LANG in procedures?

    I would like to localize an application. I've got the idea that I could use the NLS_LANG of the client session to modify the result of some stored procedures.

    I think I could make a test in the procedure like :

        if (client.NLS_LANG==FRENCH_FRANCE.etc...)then
            -- here a french message
        else....

    Has anyone ever done that or has another idea?     thanks for help.

    fgalot_at_x-lan.com Received on Tue Oct 12 1999 - 10:34:39 CDT