Re: PLSQL return varchar2 value

From: Andrew Protasov <protasov_at_percombank.kiev.ua>
Date: 1998/02/24
Message-ID: <6ctseq$7r4@post.percombank.kiev.ua>#1/1

Hi Nicolas,

Try this

select substr(f(dummy),1,200) from dual;

where f is your PL/SQL function and 200 - necessary length.

                  Andrew Protasov

Nicolas Issakides wrote in message <34f1fe9c.0_at_Kampot.pci>...
>
>When I create a view based on a select statement that includes a PL/SQL
>function that return a varchar2 value, this column is sized to the max size
>that a varchar2 field can become.
>
>How can I get that a function return a 'sized' varchar2 value
>
>
>
>Nicolas
>
>Nissakid_at_planete.net
>Microsoft Certified Product Specialist
>AUI Member
>
>The above represents my own opinion not my employer's and does not
>necessarily constitute the official policy of my employer. Any opinion
>developed through this account represent a private conversation.
Received on Tue Feb 24 1998 - 00:00:00 CST