Re: Cannot call function in query
From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/09
Message-ID: <339bc8ba.10269477_at_www.sigov.si>#1/1
Received on Mon Jun 09 1997 - 00:00:00 CEST
Date: 1997/06/09
Message-ID: <339bc8ba.10269477_at_www.sigov.si>#1/1
On Mon, 09 Jun 1997 11:09:03 +0800, Steve Corbett
<stevec_at_fcs.wa.gov.au> wrote:
>Jurij Modic wrote:
Yes, but your functions are most probably standalone stored functions.
Here we are talking about functions included in packages where pragma
RESTRICT_REFERENCES is neaded to allow calls from SQL.
AFAIK this pragma is available since 7.2. Correct me if I am wrong.
>>
>> This functionality is available from version 7.2 on. In earlier
>> releases you are not able to call PL/SQL functions from within SQL.
>
>we are using v7.1.6.2 and we can call pl/sql functions.
>[pl/sql v 2.1.6, SqlPlus v 3.1.3.7]
>
>steve.
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 Mon Jun 09 1997 - 00:00:00 CEST