Re: Bug in PL/SQL ?

Seams that it is translated two times in PL/SQL:

Try

variable xxx varchar2(9)
select translate('321xabcdef','123abc','2') from dual; exec :xxx := translate('321xabcdef','123abc','2') print xxx

2xdef for SQL select
xdef for PL/SQL

Now try

select translate('321xabcdef','123abc','1') from dual; exec :xxx := translate('321xabcdef','123abc','1') print xxx

1xdef for SQL select
1xdef for PL/SQL Received on Wed Mar 20 2002 - 03:09:45 CST