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: Bad Function

Re: Bad Function

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sun, 13 Mar 2005 00:42:17 GMT
Message-ID: <Xns9617A9EE38847SunnySD@68.6.19.6>


"mike" <hillmw_at_charter.net> wrote in
news:1110672269.496476.66230_at_g14g2000cwa.googlegroups.com:

> Can figure out why this function is bad.
>
> 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;
> return my_desc;
> end get_desc;
>
> Mike
>



I suggest you try something other than programming. Where/how/why does "my_desc" get any value? "struct_desc" is simply a column/field in "li_struct_def" table.

It is NOT a bad function.
PEBKAC is a better description. Received on Sat Mar 12 2005 - 18:42:17 CST

Original text of this message

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