Re: Tom Kyte procedure that works in 8i will not work in 9i any ideas?

From: Billy O'Connor <billy_at_dps2.dpscon.com>
Date: Thu, 25 Apr 2002 21:28:46 GMT
Message-ID: <m3adrrh3hj.fsf@dps2.dpscon.com>

Connor McDonald <connor_mcdonald_at_yahoo.com> writes:

> julio wrote:
> >
> > I have been using a procedure
> > return g_words( p_n );
> > exception

[snip code body]

>
> Worked fine for me: (9013, NT)
>
> SQL> select delimited.word('this,is,a,test',3) from dual;
>
> DELIMITED.WORD('THIS,IS,A,TEST',3)
> --------------------------------------------------------------------
> a
>
> SQL> select delimited.word('my,name,is,''o''brien',4) from dual;
>
> DELIMITED.WORD('MY,NAME,IS,''O''BRIEN',4)
> -------------------------------------------------
> o'brien
>

Worked on RedHat Linux 7.2

Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production With the Partitioning option
JServer Release 9.0.1.0.0 - Production

Package created.

Package body created.

SQL> select delimited.word('this,is,a,test',3) from dual;

DELIMITED.WORD('THIS,IS,A,TEST',3)

---

a

SQL> select delimited.word('my,name,is,''o''connor',4) from dual;

DELIMITED.WORD('MY,NAME,IS,''O''CONNOR',4)

---

o'connor

Hey, maybe you have to be Irish! (sorry, couldn't resist.)

I don't understand what the difference could be with the sun platform. This is very puzzling... Received on Thu Apr 25 2002 - 16:28:46 CDT