Re: Using Boolean functions in SQL*PLUS
From: Pauli Salmu <p.salmu_at_mn.medstroms.se>
Date: 1995/12/10
Message-ID: <4adm0a$4s5_at_zorn.mnet.medstroms.se>#1/1
Date: 1995/12/10
Message-ID: <4adm0a$4s5_at_zorn.mnet.medstroms.se>#1/1
hoffma_at_rpi.edu (Adam Hoffman) wrote:
>
> Is it possible to use a boolean function call in a SQL*PLUS routine.
> For example:
>
> select x,y,z
> from dual
> where function = 'TRUE';
>
> When I try to do this I get the message:
> ORA-06571: Function ZFDIFUND does not guarantee not to update database
>
> Is my syntax wrong or is it just not possible to use Boolean functions
> like this. Any help would be appreciated. Thanks.
>
The return type (and parameters) of the function must be Oracle Server
internal types such as CHAR, DATE, or NUMBER. That error though occurs
because there is no "pragma restrict references" defined for
the function.
Received on Sun Dec 10 1995 - 00:00:00 CET