AW: [suse-oracle] Oracle Store Procedure Problem 2006-02-21 - By CLEMENS.BLEILE@(protected)
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 (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.>
|
|
