Re: ouch
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: SUzzell@xxxxxxxxxx
- Date: Wed, 31 Aug 2011 16:44:18 -0400
perhaps they needed it to be non-deterministic.
On Wed, Aug 31, 2011 at 4:31 PM, Uzzell, Stephan <SUzzell@xxxxxxxxxx> 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*****
>
> ** **
>
Other related posts:
