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.>