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

Ulrik Hoffmann 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

It is a bug ... but probably not with Oracle ... more likely with the Unix SA or Oracle DBA: Is there a mirror handy?

Likely one of you needs to read the Oracle installation docs with respect to kernel parameters. Set them properly. Reboot.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)