Re: specifying length of return VARCHAR2

That gets my vote for cute trick of the week Thanks.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

gregory_s_at_my-deja.com wrote in message <7nsspv$sdk$1_at_nnrp1.deja.com>...
>I've come across a solution to the oft-quoted limitation of PL/SQL
>that the length of a VARCHAR2 function return cannot be specified.
>
>The typical work-around is to truncate the result where it is used
>in a view. This is makes for heavy syntax when a common function
>is used many times.
>
>However, at least in Oracle 8, one can do the following:
>
>dummy_variable VARCHAR2(150);
>SUBTYPE t_return IS dummy_variable%TYPE;
>FUNCTION get (ix IN NUMBER) RETURN t_return;
>
>Works nicely. Hope that helps.
Received on Fri Jul 30 1999 - 14:25:26 CDT