Re: { oracle 7 } pb with the return of stored function

Originally posted by @Rennes
> i have a stored function where his return are varchar2(40).
> Thir return his written like this tbl.field%TYPE
>
> This function is call by 5 views.
> But the type of the field returned by function are varchar2(2000).
>
> How could i take correction ?
>

In the view you could select SUBSTR(thefunction(...),1,20). Then the view column will be VARCHAR2(20)

--
Posted via http://dbforums.com