SEE comment
>> 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;
>
>
Comment
(But not if its declared in the same package, as it is in my case).
Additionally, I have to call it through sql as it is part of a decode
statement.
>--
End Comment
>David Fitzjarrell
>Oracle Certified DBA
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Oct 27 2000 - 03:31:15 CDT