Re: PLSQL return varchar2 value
From: Gert Rijs <nospampleasegem_at_wirehub.nl>
Date: 1998/02/24
Message-ID: <01bd40e2$5cec79b0$0100007f_at_gertrijs>#1/1
Date: 1998/02/24
Message-ID: <01bd40e2$5cec79b0$0100007f_at_gertrijs>#1/1
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>...Received on Tue Feb 24 1998 - 00:00:00 CET
>
> 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
>