NUMBER vs BOOLEAN in Oracle OPERATOR

From: Spencer <sburgeon_at_hotmail.com>
Date: 19 Jul 2002 07:02:43 -0700
Message-ID: <af7460c0.0207190602.4730d0f0@posting.google.com>

Hello everyone. Despite the apparently obvious error message given by Oracle, can someone please tell me why the first operation below works, and the second one doesn't. I don't understand. Isn't a BOOLEAN just like any other Oracle internal datatype (eg VARCHAR2, NUMBER) ?

Thank you
Spencer

SQL> CREATE OR REPLACE FUNCTION bt_opTest(datain1 VARCHAR2,datain2 VARCHAR2) RETURN NUMBER AS
  2 BEGIN
  3 RETURN 1;
  4 END;
  5 /

Function created.

SQL>
SQL> CREATE OR REPLACE OPERATOR opTest BINDING(VARCHAR2,VARCHAR2) RETURN NUMBER USING bt_opTest;

Operator created.

SQL>
SQL> DROP OPERATOR opTest;

Operator dropped.

SQL> DROP FUNCTION bt_opTest;

Function dropped.

SQL> 
SQL> 
SQL> CREATE OR REPLACE FUNCTION bt_opTest(datain1 VARCHAR2,datain2

VARCHAR2) RETURN BOOLEAN AS
  2 BEGIN
  3 RETURN TRUE;
  4 END;
  5 /

Function created.

SQL>
SQL> CREATE OR REPLACE OPERATOR opTest BINDING(VARCHAR2,VARCHAR2) RETURN BOOLEAN USING bt_fred;
CREATE OR REPLACE OPERATOR opTest BINDING(VARCHAR2,VARCHAR2) RETURN BOOLEAN USING bt_opTest;
*
ERROR at line 1:
ORA-06552: PL/SQL: Declaration ignored
ORA-06553: PLS-201: identifier 'SCOTT.BOOLEAN' must be declared

SQL>
SQL> Received on Fri Jul 19 2002 - 09:02:43 CDT