ORA-01460 error on Oracle

Asked

Viewed 1,443 times

2

I have the trial 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 receive strings with XML data, and inside the Procedure I convert to XML. As below:

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

When I get file bigger than 32.000 Bytes Oracle is returning me the message below:

Ora-01460: Unsolvable or unsolvable conversion requested.

What can I do to fix this? I have to change the type of my parameter will be?

xml oracle procedure

1 answer

1

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

another solution is to use the data type as CLOB.

Browser other questions tagged xml oracle procedure

You are not signed in. Login or sign up in order to post.