Re: Boolean Function Problem.

boolean is pl/sql only, you CAN'T use it in ordinary sql, so not in function returns.

Hth,

Sybrand Bakker, Oracle DBA

Moore <rlmoore_at_purdue.edu> wrote in message news:Pine.SOL.4.10.10003151627110.15285-100000_at_herald.cc.purdue.edu...
> 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
>
Received on Wed Mar 15 2000 - 15:42:23 CST