RES: [suse-oracle] Oracle Store Procedure Problem 2006-02-20 - By José Pitombeira
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 (See ORA-00600.ora-code.com): internal error code, argument: [17147], [0x2A97BF54E0], [], [],
[], [], [], []
ORA-06502 (See ORA-06502.ora-code.com): PL/SQL: value or numeric error
ORA-06512 (See ORA-06512.ora-code.com): in line 3
What’s wrong?
Thank you.
|
|
