Re: Cannot call function in query
Date: 1997/06/07
Message-ID: <3399b3ae.16625667_at_www.sigov.si>#1/1
On Fri, 06 Jun 1997 15:10:50 +0200, Ansgar Seiter <seiter_at_phya5.physik.uni-freiburg.de> wrote:
>What Server Version do I need ?
>I've done all the above, but keep getting errors like 'invalid function'
>with packaged or not packaged functions (Server 7.0.16).
>
>rgds,
>Ansgar
>
>N Prabhakar wrote:
>> Hi there
>>
>> you need to use pragma restrict references to call a function from the sql query. Define the pragma at the package header
>>
>> PRAGMA RESTRICT_REFERENCES (get_concat_description, WNDS, WNPS );
>>
>> get_concat_description is the function name and you should define
>> the above line in the package header
[Quoted] [Quoted] This functionality is available from version 7.2 on. In earlier releases you are not able to call PL/SQL functions from within SQL.
Regards,
Jurij Modic Republic of Slovenia tel: +386 61 178 55 14 Ministry of Finance fax: +386 61 21 45 84 Zupanciceva 3e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000
Received on Sat Jun 07 1997 - 00:00:00 CEST