How to limit the size of the returned value from a Stored Function?
From: Vahidt A. Tadjkarimi <vahidt_at_ibm530.vitek.com>
Date: 1996/11/11
Message-ID: <567h0h$7n3_at_news.starnet.net>#1/1
Date: 1996/11/11
Message-ID: <567h0h$7n3_at_news.starnet.net>#1/1
I was wondering if it is possible to limit the size of a returned value from a Stored Function. Here is a small example:
CREATE OR REPLACE FUNCTION plus_minus_f (val_1 IN NUMBER, val_2 IN NUMBER) RETURN CHAR IS
BEGIN
IF ((val_1 - val_2)/val_2) > 0.20) THEN
RETURN ('+');
ELSE
RETURN ('-')
END IF;
END;
/
Once I call this function from a view or by itself the size of the returned value is VARCHAR2(2000) !!! Any hints? Received on Mon Nov 11 1996 - 00:00:00 CET