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

Ulrik Hoffmann <ulrik.1und1news_at_hoffmann-kiel.de> wrote:
> 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

The same thing happens on my system:

Oracle Enterprise 10.2.0.1.0 on RHEL 3 (Update 5), charset AL32UTF8.

What causes the 'ORA-03113: end-of-file on communication channel' is a core dump of the server process for this client.

You can find the core dump in $ORACLE_BASE/admin/cdump and a lengthy trace file in $ORACLE_BASE/admin/udump.

If you read the latter you will find that the core dump is caused by Exception signal: 8 (SIGFPE), code: 1 (Integer divide by zero).

This is definitely a bug, and I would open a TAR for it.

Yours,
Laurenz Albe Received on Thu Dec 15 2005 - 01:49:30 CST