Re: Function FunctionName may not be used in SQL

In article <8t9eju$76u$1_at_kermit.esat.net>,   "Keith Jamieson" <Keith.Jamieson_at_phoenix.ie> wrote:
>
> 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.
>
>

Since the functions are part of a package that package name must be included in the function call:

x:=packageName.functionName;

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.