Re: Bug in PL/SQL ?

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 19 Mar 2002 12:21:11 GMT
Message-ID: <a77afn$dk4$1@news.liv.ac.uk>

,Peter Yu <yuyh_at_sp.edu.sg> wrote:
: 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 ???

Works fine in 9.0.1, but in 7.3.4, 8.1.5 and 8.1.7 getting xdef in PL/SQL.

Helen

/\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ /\/\ ( oo ) ( oo ) ( oo ) ( oo ) ( oo ) ( ** ) ( oo ) ( oo ) ( oo ) ( oo ) ( oo ) =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= =^^= Received on Tue Mar 19 2002 - 06:21:11 CST