BOOLEAN parameter passed to a stored function

From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: Sun, 03 Jun 2001 01:56:24 +0800
Message-ID: <4t9ihtcahls3dn9b1dnm1rprc9mojek7b0@4ax.com>

Dear all,

The following function takes BOOLEAN parameters:

CREATE OR REPLACE FUNCTION sf_case
(i_case1 IN BOOLEAN DEFAULT FALSE,
 i_case2 IN BOOLEAN DEFAULT FALSE)
RETURN INTEGER
IS

    v_result INTEGER;
BEGIN
    IF i_case1 THEN

        v_result := 1;
    ELSIF i_case2 THEN

        v_result := 2;
    ELSE
        v_result := 0;
    END IF;
    RETURN v_result;
END;
/

However, when I try it in SQL*Plus, logical expressions cannot be evaluated before passed into the stored function: (only literal TRUE and FALSE will be accepted)

SQL> SELECT SF_CASE(2>1,2>1) FROM DUAL;
SELECT SF_CASE(2>1,2>1) FROM DUAL

                *

ERROR at line 1:
ORA-00907: missing right parenthesis

Anyone can help? (Oracle 8.0.5) Thanks in advance.

Dino Received on Sat Jun 02 2001 - 12:56:24 CDT