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: Cannot call function in query

Re: Cannot call function in query

From: Jurij Modic <jurij.modic_at_mf.sigov.mail.si>
Date: 1997/06/09
Message-ID: <339bc8ba.10269477@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:
>>
>> 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.

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.

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 Mon Jun 09 1997 - 00:00:00 CDT

Original text of this message

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