Re: Bug in PL/SQL ?

"justme" <someq_at_rogers.com> wrote in message news:R5Il8.46$oG11.37_at_news01.bloor.is.net.cable.rogers.com...
> Oracle9i Enterprise Edition Release 9.0.1.1.1
> Returns the same result "axdef"
>
> "Peter Yu" <yuyh_at_sp.edu.sg> wrote in message
> news:3c96d746$1_at_sspwb100.sp.edu.sg...
> > Try this in sqlplus:
> >
> > variable xxx varchar2(9)
> >
> > select translate(translate('321xabcdef','123abc','a'),'b','b') from
dual;
> > exec :xxx := translate(translate('321xabcdef','123abc','a'),'b','b');
> > print xxx
> >
> > The above give 2 different results:
> >
> > axdef for SQL select
> >
> > xdef for PL/SQL
> >
> > Is this a bug ???
> >

Yup - looks like it. I can reproduce your example but can't find any other examples.
BTW the outer translate is superflouous and just confuses the issue. translate('321xabcdef','123abc','a') seems to return 'xdef' in PL/SQL which is wrong.

Ray Received on Mon Mar 25 2002 - 19:43:30 CST