Re: Using Packages in Oracle forms

From: Andy Hardy <aph_at_ahardy.demon.co.uk>
Date: Mon, 10 May 1999 11:23:23 +0100
Message-ID: <hTSAeFAbOrN3Ew5w@ahardy.demon.co.uk>

In article <3736A44B.C7E45969_at_knold.ballehs.dk>, Michael Holm <datb9812_at_knold.ballehs.dk> writes
>Hi
>
>i'm trying to use a package that I have created user forms 4.5. I keep
>getting this error: Funktion 'text_to' may not be used in SQL. I have
>created the package with the funktion but it won't work. I'm tried it
>under the SQL program for forms and then it worked, I just don't know
>why it didn't worked under Foms.
>

Can you show us the package declaration and your call to the package?

The package is compiled on your database, and the call works from SQL*Plus?

Have you put RESTRICT_REFERENCES in the package declaration? E.G

PACKAGE return_value
IS

        FUNCTION material_description (p_material_id materials.material_id%TYPE)

        RETURN VARCHAR2
        ;
        PRAGMA RESTRICT_REFERENCES(material_description, WNDS, WNPS);

END;
--
Andy Hardy. PGP key available on request

---

Received on Mon May 10 1999 - 05:23:23 CDT