Error ORA-01460 in Oracle

Question

Error ORA-01460 in Oracle

Navigation

#1 by (1 votes)

2

I have the procedure below:

PROCEDURE GRAVA_(P_IMEI_DISPOSITIVO IN NVARCHAR2,
                              P          LONG,
                              P_DET      LONG,
                              RETORNO_OPERACAO   OUT VARCHAR2)

In the P and P_DET parameters I get strings with data in XML, and inside the procedure convert to XML. As below:

PL_MZ_CAB_XML           SYS.XMLTYPE;
PL_MZ_CAB_XML := SYS.XMLTYPE.CREATEXML(P);

When I get a file larger than 32,000 Bytes Oracle is returning the message below:

Ora-01460: Replication not implemented or not resolved.

What can I do to resolve this? Do I have to change what kind of my parameter will be?

oracle procedure xml

asked by anonymous 20.01.2015 / 14:04

1 answer

How to retrieve the attribute of a dynamically created element? How to design check-in policies only after a Get Last Version in TFS 2012?

score 1 · Answer 1

You have not talked about your Oracle version, but it is probably less than 10.1.0.5. This error occurs in older versions of Oracle. Another possible problem is the outdated JDBC driver.

Another solution is to use the data type as CLOB.