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

On Wed, 14 Dec 2005 20:36:30 +0100, "Ulrik Hoffmann" <ulrik.1und1news_at_hoffmann-kiel.de> wrote:

>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

Hi Uli,

Database Version = Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

Both procs work without any problem at all. Best Regards

Rob Zijlstra Received on Wed Dec 14 2005 - 14:03:58 CST