Package function problems

From: Walter Dnes <waltdnes_at_interlog.com>
Date: Sun, 07 Mar 1999 03:22:40 GMT
Message-ID: <36e5e467.78098546@news.interlog.com>

I'm trying to call my own package function from a SELECT statement. I get the following error message...

SQL> SELECT WD.INT_STN_ID('6158733') AS STATION FROM SYS.DUAL; ERROR:

ORA-04068: existing state of packages has been discarded
ORA-04063: package body "XXXXXXX.WD" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1


==============================================================

I've spec'd the function in package WD like so...

FUNCTION INT_STN_ID(STN7CHAR VARCHAR2) RETURN NUMBER; PRAGMA RESTRICT_REFERENCES (INT_STN_ID, WNDS, WNPS); It basically does a SELECT INTO ...; does some error checking and returns either the result, or NULL if an error is found. Anyone have any idea what gives?

--
Walter Dnes <waltdnes_at_interlog.com> procmail spamfilter http://www.interlog.com/~waltdnes/spamdunk/spamdunk.htm Why a fiscal conservative opposes Toronto 2008 OWE-lympics http://www.interlog.com/~waltdnes/owe-lympics/owe-lympics.htm Received on Sat Mar 06 1999 - 21:22:40 CST