Re: Boolean Function Problem.

From: SKurosky <skurosky_at_aol.com>
Date: 15 Mar 2000 23:55:00 GMT
Message-ID: <20000315185500.02631.00001977@ng-fh1.aol.com>

>MOORE WROTE:

>Oh please help me!
>
>What is wrong?
>
>SQL> CREATE OR REPLACE
> 2 FUNCTION FOO RETURN BOOLEAN IS
> 3 BEGIN
> 4 RETURN TRUE;
> 5 END FOO;
> 6 /
>
>Function created.
>
>SQL> select foo from dual;
>ERROR:
>ORA-06550: line 1, column 12:
>PLS-00382: expression is of wrong type
>ORA-06550: line 1, column 7:
>PL/SQL: Statement ignored
>
>
>no rows selected
>
>Hi,

There is no Boolean datatype in oracle. Just PL/SQL Sandy

>
>
>
>
>
Received on Wed Mar 15 2000 - 17:55:00 CST