Re: Cannot call function in query

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/07
Message-ID: <3399b3ae.16625667@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

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 3

e-mail: jurij.modic_at_mf.sigov.mail.si Ljubljana 1000

---

Received on Sat Jun 07 1997 - 00:00:00 CDT