Re: Bad Function

On 12 Mar 2005 16:04:29 -0800, "mike" <hillmw_at_charter.net> wrote:

>Can figure out why this function is bad.

 Then why post..?

>create or replace function get_desc ( field number )
>return varchar2 as
> my_desc varchar2(50);
>begin
> select struct_desc from li_struct_def where struct_def_id=field;

 You do a select - but what are you selecting into?

> return my_desc;
>end get_desc;

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool