PLSQL return varchar2 value

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 Mon Feb 23 1998 - 00:00:00 CST