Re: How to limit the size of the returned value from a Stored Function?

you might try to use one of the TRIM functions on the return value

Randy :)

Vahidt A. Tadjkarimi (vahidt_at_ibm530.vitek.com) wrote:
: 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?

--
    ..uu.           Randy DeWoolfson          ----------------------
  .?$" '?i     .                              I  randyd_at_cais.com   I
 .T^M  ._at_"    d9    .    .f   ,.un.  t     ,  I--------------------I
 "  Z :#"    M `8   U    <  .dP"``Y# `M   _at_"  I brandall_at_erols.com I
    &H?`    Xl _R   $5.  $  ?*    _at_   'P,#"   I--------------------I
  ,d#^*L   :RP'~$b  f`$L:M  Xf  .f'    dH`    I     ,\//.      X   I
    &  'M ,P    `E  M   "$  Mux~      n!`     I     |o o|          I
   dk   `h"       ' j     " y"       *~       I=oOO==(_)==Ooo======I