Checou formato de datas, tipo de dados ou coisas assim ??







_____

De: Rodrigo Morato Rodrigues [mailto:rgmorato@(protected)]
Enviada em: Monday, February 20, 2006 5:21 PM
Para: suse-oracle@(protected)
Assunto: [suse-oracle] Oracle Store Procedure Problem





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,EMPT
Y_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.