Re: Returning TRUE and FALSE in Oracle 7.1.5.2.3

From: Tommy Wareing <p0070621_at_brookes.ac.uk>
Date: Mon, 19 Oct 1998 08:59:33 GMT
Message-ID: <362afd1f.496654871@news.brookes.ac.uk>

On 18 Oct 1998 13:56:39 GMT, gennick_at_worldnet.att.net (Jonathan Gennick) wrote:

>On Sun, 18 Oct 1998 01:43:22 GMT, tkyte_at_us.oracle.com
>(Thomas Kyte) wrote:
>
>>booleans cannot be stored in a table in 7.x as a native datatype, this is true.
>>However, pl/sql functions may certainly return booleans as demonstrated. I
>>don't know what issue there might be with 7.1.5 and forms 3.x with booleans,
>>however, booleans are defintely allowed.
>
>You're right. Now that you point it out, I think I've done
>it myself in the past. I must have been confused and
>remembering what happens when you try to use such a function
>in a query. In the past, I've tried to use boolean functions
>in query where clauses, but without success.

PL/SQL v.1, as used in forms 3 and in 4.5 (I could be wrong on the latter, 'cos I don't writ emuch in it) doesn't support boolean return types.

You can't even use
function_taking_boolean(function_returning_boolean)

--
Tommy Wareing
MIS Group
Learning Resources
Oxford Brookes University
01865 483389 Received on Mon Oct 19 1998 - 03:59:33 CDT