Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Function FunctionName may not be used in SQL

Re: Function FunctionName may not be used in SQL

From: Keith Jamieson <Keith.Jamieson_at_phoenix.ie>
Date: Fri, 27 Oct 2000 09:31:15 +0100
Message-ID: <8tbeke$1o8$1@kermit.esat.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US