Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Boolean Function Problem.

Boolean Function Problem.

From: Moore <rlmoore_at_purdue.edu>
Date: Wed, 15 Mar 2000 16:28:53 -0500
Message-ID: <Pine.SOL.4.10.10003151627110.15285-100000@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:28:53 CST

Original text of this message

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