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

Vahidt A. Tadjkarimi 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
>
> Once I call this function from a view or by itself the size of the
> returned value is VARCHAR2(2000) !!! Any hints?

  You can try to use:
  CREATE OR REPLACE FUNCTION plus_minus_f (val_1 IN NUMBER, val_2 INNUMBER)
  RETURN VARCHAR2

-- 
Name        : Lun Wing San
Title       : Oracle developer of the Hong Kong Productivity Council
              System Administrator and Oracle DBA of the Quick Response
Center
Email Addr. : sunny_at_hkpc.org
Telephone   : 852-2788-5841