Devart Forums

Hi,
me again...

It looks like there are some issues regarding TOraXMLFields of a certain size. Using your XML-Demo (XMLType.dpr) i am able to update the Fields of type XMLTYPE without problems. But as soon as the Size of the XMLCode exceeds 4096 bytes I get the following error:

ORA:03118: Two-Task Coroutine not valid (since I use the german version of oracle the english Message may be slightly different).

This can´t be a problem of oracle since using the following PL/SQL-Proc I was able to import XML-files into Records in the database wich sizes were 12 KB and more...

DBMS_LOB.createtemporary (l_clob, TRUE);

DBMS_LOB.fileopen(l_bfile);
DBMS_LOB.loadfromfile(l_clob, l_bfile, DBMS_LOB.getlength(l_bfile));
DBMS_LOB.fileclose(l_bfile);

INSERT INTO sev.xml_tab (
XML_ID,
XML_Filename,
XML_XMLCode,
XML_VERARBEITET
)
VALUES (
xml_tab_seq.NEXTVAL,
p_filename,
XMLTYPE.createXML(l_clob),
'Nein'
);
COMMIT;

DBMS_LOB.freetemporary (l_clob);

Can anyone help me on this?

Thanks!

This is a known problem of Client 9.2.0.1.0, Server 9.2.0.1.0. This problem is fixed in 9.2.0.3.0 version.
You can pass XMLType as Lob parameter in your example.

Paul wrote:This is a known problem of Client 9.2.0.1.0, Server 9.2.0.1.0. This problem is fixed in 9.2.0.3.0 version.
You can pass XMLType as Lob parameter in your example.

I just tried it with Server 9.2.0.6 but unfortunately still with Client 9.2.0.1 and it didn´t work. Do I really have to update both Client and Server?

adeptus wrote:

Paul wrote:This is a known problem of Client 9.2.0.1.0, Server 9.2.0.1.0. This problem is fixed in 9.2.0.3.0 version.
You can pass XMLType as Lob parameter in your example.

I just tried it with Server 9.2.0.6 but unfortunately still with Client 9.2.0.1 and it didn´t work. Do I really have to update both Client and Server?

Yes it has to be... I got it to work with both server and client 9.2.0.6!

Thanks for the tip!