Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: { oracle 7 } pb with the return of stored function

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

From: andrewst <member14183_at_dbforums.com>
Date: Tue, 17 Jun 2003 15:16:03 +0000
Message-ID: <3011652.1055862963@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 Tue Jun 17 2003 - 10:16:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US