Function FunctionName may not be used in SQL

From: Keith Jamieson <Keith.Jamieson_at_phoenix.ie>
Date: Thu, 26 Oct 2000 15:18:37 +0100
Message-ID: <8t9eju$76u$1@kermit.esat.net>

I have a package, which contains a SQl statement which has a function call on a column value;
I only want these functions to be local to the Package only. If I declare the function inside the package only, I get a message PLS-00231 saying that the function is proscribed(Not Allowed).

I can get everything to work if I declare the functions in the package header, and add PRAGMA RESTRICT_REFERENCE syntax for each function. However, this makes these functions Public.

for various reasons, I cannot call the function in the form x := functionName.

Vesions

---

ORACLE 8.06.0.0
Pl/SQL 8.0.6.0.0. Received on Thu Oct 26 2000 - 09:18:37 CDT