Re: Newbie : PL/SQL Function Return value

Thanks Stefan - that's done the trick.

Regards,
Lee.

Stefan Grundmann <s.grundmann_at_t-online.de> wrote in message news:8nbumg$4rg$15$1_at_news.t-online.com...
> Hello Lee!
>
> You have to limit to length of your function-based-columns in the related
> view by using Oracles function substr().
>
> create or replace view example_view
> as
> select
> ...
> substr ( your_function(...), 1, xxx ) your_column_name,
> ...
> from
> ...
>
>
> where xxx is the appropriate length of the column you need.
>
> The problem is, that in Oracle the return-type cannot be limited. So the
> varchar2-return-type is of length 4000 (or greater, if Oracle changes
 that).
>
> Stefan
>
Received on Wed Aug 16 2000 - 01:44:14 CDT