Re: ouch

From: Paul Drake <bdbafh_at_gmail.com>
Date: Wed, 31 Aug 2011 16:44:18 -0400
Message-ID: <CAPptggVdA=+SavJ0kQknk7h2o1-k5YkBHTxi9BCs6T9RDbfrFw_at_mail.gmail.com>

perhaps they needed it to be non-deterministic.

On Wed, Aug 31, 2011 at 4:31 PM, Uzzell, Stephan <SUzzell_at_micros.com> wrote:

> Found a gem in one of my databases today:****
>
> ** **
>
> FUNCTION "SUBSTRING"****
>
> (INSTRING IN varchar2,****
>
> STARTPOS IN number,****
>
> LENGTH IN number)****
>
> RETURN varchar2****
>
> IS****
>
> RESULT varchar2(8000);****
>
> BEGIN****
>
> select substr(INSTRING, STARTPOS, LENGTH)****
>
> into RESULT****
>
> from DUAL;****
>
> RETURN(RESULT);****
>
> END;****
>
> ** **
>
> I’m offended by the sheer aesthetics of this. And I want to go yell at the
> developers that this is wrong. But I’d need a better argument than that it
> offends me. Is there some way to quantify the impact (if any) of wrapping a
> built-in function like this?****
>
> ** **
>
> *Stephan Uzzell*****
>
> ** **
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 31 2011 - 15:44:18 CDT