10gR2 PL/SQL-Bug ora-03113 with chr()

From: Ulrik Hoffmann <ulrik.1und1news_at_hoffmann-kiel.de>
Date: Wed, 14 Dec 2005 20:36:30 +0100
Message-ID: <op.s1sgq4r4dm852a@papa>

Hi all,

is this a bug or a feature or am I missing something?

The following statement works with chr(193) but throws an ora-03113 with chr(194). Strange behaviour, isn't it?

SQL> declare

   2 v_retval varchar2(255):='HALLO';    3 begin
   4 v_retval:=REPLACE(v_retval,CHR(193),'1');    5 end;
   6 /

PL/SQL procedure successfully completed.

SQL> declare

   2 v_retval varchar2(255):='HALLO';    3 begin
   4 v_retval:=REPLACE(v_retval,CHR(194),'1');    5 end;
   6 /
  declare
*
ERROR at line 1:
ORA-03113: Unerwartetes Übertragungsende in Kommunikation

With sql (select REPLACE('Hallo',CHR(194),'1') from dual) it works.

Database: 10.2.0.1
OS: SLES-9
NLS_CHARSET: AL32UTF8 Any comments? Is it a known bug? Cant find anything on it at metalink.

Same works fine on 10.1.0.4 on SLES-9 but with WE8ISO8859P1

Bye
Uli Received on Wed Dec 14 2005 - 13:36:30 CST