Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NUMBER vs BOOLEAN in Oracle OPERATOR
My guess is that it is because there is no Boolean data type in Oracle for
columns.
Jim
"Spencer" <sburgeon_at_hotmail.com> wrote in message
news:af7460c0.0207190602.4730d0f0_at_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 - 22:47:45 CDT