Re: Bug in PL/SQL ?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 19 Mar 2002 12:22:29 -0000
Message-ID: <3c972d86$0$230$ed9e5944@reading.news.pipex.net>

I get the different results on 8.1.6.1,8.1.6.3 and 8.1.7.2 hope this helps clarify.

SQL> / BANNER

---

Oracle8i Release 8.1.7.2.1 - Production
PL/SQL Release 8.1.7.2.0 - Production
CORE 8.1.7.2.1 Production
TNS for 32-bit Windows: Version 8.1.7.2.0 - Production NLSRTL Version 3.4.1.0.0 - Production

SQL> variable xxx varchar2(9)
SQL>
SQL> select translate(translate('321xabcdef','123abc','a'),'b','b') from

dual;

TRANS

---

axdef

SQL> exec :xxx := translate(translate('321xabcdef','123abc','a'),'b','b');

PL/SQL procedure successfully completed.

SQL> print xxx

XXX

---

xdef

SQL> perhaps you could post version on which the results are the same.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Ben de Boer" <B.deBoer_at_Canon-Europa.com> wrote in message
news:Xns91D6741B9D1F6BdeBoerCanonEuropaco_at_212.26.18.3...


> "Peter Yu" <yuyh_at_sp.edu.sg> wrote in news:3c96d746$1_at_sspwb100.sp.edu.sg:

>
>
> It is working with me just fine.

Received on Tue Mar 19 2002 - 06:22:29 CST