Re: Can't use local function in select statement

From: Frank <franjoe_at_frisurf.no>
Date: Tue, 3 Apr 2001 21:56:08 +0200
Message-ID: <BVpy6.3722$R6.80154@news1.oke.nextra.no>

Hi!
Have a look a PRAGMA RESTRICT_REFERENCES in Oracle Documentation; it may help to add someting like:
PRAGMA RESTRICT_REFERENCES l_is_numeric, WNDS, WNPS, RNDS, RNPS); after a function declaration.

I tried it myself now, and it seems that Oracle whish that this pragma is used in a package specification.
It seems to me that you have to move your local function (i_is_numeric) to a package and add the pragma
to the specification, and then call the function from that package here in this procedure instead.

Frank Received on Tue Apr 03 2001 - 14:56:08 CDT