Hi Rodrigo,
below an excerpt.
Ciao
Clemens
PURPOSE:        
This article discusses the internal error "ORA-600 [17147]", what
it means and possible actions. The information here is only applicable
to the versions listed and is provided only for guidance.

ERROR:        
ORA-600 [17147] [a] [b] [c] [d] [e]

VERSIONS:      
versions 7.0 to 9.2

DESCRIPTION:    

Oracle has detected that the magic number in a memory chunk header has
been overwritten.

This is a heap (in memory) corruption and there is no underlying data
corruption.

The error may occur in the one of the process specific heaps
(the Call heap, PGA heap, or session heap) or in the shared heap (SGA).

FUNCTIONALITY:    
HEAP MANAGEMENT

IMPACT:        
PROCESS FAILURE
MEMORY CORRUPTION, POSSIBLE INSTANCE FAILURE.
NON DATA CORRUPTIVE - No underlying data corruption.

SUGGESTIONS:

Many are one time occurrances.

Please see if the problem is reproducable.

Have the hardware vendor check all system memory for possible errors.

For repeatable occurrances, please submit the trace
files and alert.log to Oracle Support Services for further analysis.


--- Originalnachricht ---



       Hi Clemens.
       I dont?t have access to Metalink. Could you send to me?
Thank?s.




De: CLEMENS.BLEILE@(protected)]
Enviada em: terça-feira, 21 de fevereiro de 2006 07:29
Para: Rodrigo Morato Rodrigues; suse-oracle@(protected)
Assunto: AW: [suse-oracle] Oracle Store Procedure Problem

Hi Rodrigo,

please check Metalink Note 138580.1

Ciao

Clemens


--- Originalnachricht ---
 
I have an Oracle 9.2 in Suse Linux (both 64 BITS) and installed another computer Suse 9 Enterprise (SP3) and Oracle 10gR2 (both 64 BITS). I did export (exp) and import (imp) from 9.2 to 10gR2 (there isn?t errors).

Now, I have a procedure that worked in Oracle 9.2 e doesn?t work in my program (done with Delphi) using Oracle 10gR2.

Procedure (name: atualizaparecer)

(p_Origem VARCHAR2, p_Tipo VARCHAR2,
p_Ano VARCHAR2, p_codigo VARCHAR2, p_Data DATE, p_TipoPar VARCHAR2,p_Assunto VARCHAR2,
p_Procurador VARCHAR2 ,p_Parecer OUT CLOB)
is
begin
INSERT INTO TBPP (Origem,Tipo,Ano,Codigo,Data,TipoPar,Procurador,Assunto,Parecer)
VALUES (p_Origem,p_Tipo,p_Ano,p_Codigo,p_Data,p_TipoPar,p_Procurador,p_Assunto,EMPTY_CLOB())
RETURNING PARECER
INTO P_Parecer;
end;

Error:
ORA-00600: internal error code, argument: [17147], [0x2A97BF54E0], [], [], [], [], [], []
ORA-06502: PL/SQL: value or numeric error
ORA-06512: in line 3

       
What?s wrong?

               Thank you.>

>