Re: Packages - newbie Q

Steve,

if you have Oracle Books online installed, please look for RESTRICT_REFERENCES in the Oracle7 Server Application Developer's Guide. Your package needs a line like:

CREATE OR REPLACE PACKAGE StevesPackage
AS

/* Declaration */

        FUNCTION fn_phonetic( surname IN VARCHAR ) RETURN VARCHAR;

/* package global vars */

/* package global consts */

/* pragma referenes for WNDS (Write No Database Status */
        PRAGMA RESTRICT_REFERENCES ( fn_phonetic, WNDS );

END StevesPackage;

HTH,

-- 
Dietmar Leibecke
----------------
Address is altered to discourage junk mail.
Remove ".---" for the real address.