Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: { oracle 7 } pb with the return of stored function
yes, i can, but i search the explication of this problem
"andrewst" <member14183_at_dbforums.com> a écrit dans le message de news:
3011652.1055862963_at_dbforums.com...
>
> 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
Received on Wed Jun 18 2003 - 03:05:25 CDT
![]() |
![]() |