Xref: alice comp.databases.oracle.misc:15052
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!newsfeed.internetmci.com!205.231.236.10!newspeer.monmouth.com!demos!carrier.kiev.ua!news.alkar.net!aladon!ktts!news.kharkiv.net!babaj!grant.grant.UUCP!postmaster
From: "Alexander I. Doroshko" <aid@grant.kharkov.ua>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Oracle views and function problems
Date: 5 May 1998 17:20:08 GMT
Organization: Kharkov, Ukraine
Lines: 17
Distribution: world
Message-ID: <01bd7849$5b076940$190114c1@sister.grant.UUCP>
References: <6ilvm7$m5l$1@nnrp1.dejanews.com>
X-Newsreader: Microsoft Internet News 4.70.1161

CREATE OR REPLACE VIEW V_ACTUALS AS SELECT substr(lineitem(accnbri), 1, 5)
as line_item, 
etc.


dbarker@tpgi.com.au wrote in article <6ilvm7$m5l$1@nnrp1.dejanews.com>...
> I have created an Oracle function that takes one input VARCHAR parameter
and
> returns a VARCHAR2(5) value.  I have created a view that selects records
from
> a table and uses this function.  When I perform a DESC on the view the
> function is of type VARCHAR2(2000).  Does anybody have any ideas?
> ...
> CREATE OR REPLACE VIEW V_ACTUALS AS SELECT lineitem(accnbri) as
line_item,
> glf_ldg_acct.* FROM glf_ldg_acct