Help with CLOB

rgmorato · Post by **rgmorato** » Mon 13 Mar 2006 16:30

Hi.
I have an application made in Delphi 6 using ODAC 4.05, Oracle 9.2/Suse Linux Enterprise 9(64 bits). Now, I would like to exchange to Oracle 10g.
I installed Oracle 10g/Suse Linux Enterprise 9 (Service Pack 3) on IBM Server 236 and did export/import ok, but the procedure bellow stoped works. I get the following error:

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

-CREATE PROCEDURE 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
UPDATE TBPP
SET
Parecer = EMPTY_CLOB()
WHERE
Origem = p_Origem and Tipo = p_Tipo and Ano = p_Ano and Codigo = p_Codigo and Ano = p_Ano
RETURNING
Parecer
INTO
p_Parecer;
end;

What's wrong?

Thank you in advanced.

Challenger · Post by **Challenger** » Tue 14 Mar 2006 12:39

The support for Oralce 10g was added in ODAC 5.00. Please try your example on the latest version of ODAC.

rgmorato · Post by **rgmorato** » Tue 14 Mar 2006 15:17

Do I need just recompile my program using ODAC 5.X instead of version 4.x in Delphi 6? Are all components of 5.x compatible with version 4.x?

Thank's.

challenger wrote:The support for Oralce 10g was added in ODAC 5.00. Please try your example on the latest version of ODAC.

Challenger · Post by **Challenger** » Tue 14 Mar 2006 15:56

Yes, they are compatible.