I don't think you can let the procedure return a 'specific sized' varchar2,
but you can create your view like:
create view v as
select substr(plfunc(column),1,10) as funcresult
...
hth,
gert
--
reply address is altered to keep the spam down
remove the nospamplease part to reply...
Nicolas Issakides <nissakid_at_planete.net> wrote in article
<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
>
Received on Tue Feb 24 1998 - 00:00:00 CST
