Oracle和VB.NET中的XMLType [英] XMLType in Oracle and VB.NET

问题描述

你好，

我对来自WebService的某些字符串有疑问.

情况是:

-我从网络服务接收到较大的XML文件
-此XML作为xml_data字符串的参数发送到webservice函数:

Hello,

I have a problem with some string from WebService.

The situation is:

- I receive large XML files from webservice
- this XML is sended to webservice function as parameter to xml_data string:

Public Function orderDownload(ByVal xml_data As String)

-在此函数中，我调用Oracle过程，该过程将解析此XML并将数据插入到适当的表中
-捕获此XML的Oracle上的参数是LONG dataype，后来被转换为xmltype，代码为:

- in this function I call Oracle procedure which parse this XML and insert data to proper table
- paramater on Oracle which catches this XML is LONG dataype, and later is converted do xmltype with code:

v_xml xmltype := xmltype(data_to_insert);

-如果XML很小，那么它就没有问题-它可以正确解析
-如果xml变大，我会收到异常消息:"ORA-01460:请求未实现或不合理的转换"

我在其中插入解析值的故事中的列是VARCHAR2(4000).

有人可以帮我处理这个例外情况吗?我认为此xml的长度存在一些问题，但我不确定.

- if XML comes small there is no problem with it - it parses crrectly
- if xml comes large i receive an exception: "ORA-01460: unimplemented or unreasonable conversion requested"

columns in tale where I insert parsed values are VARCHAR2(4000).

Can anyone help me handle with this exception? I think there is some problem with lenght of this xml, but I''m not sure.

推荐答案

可能有多种原因.例如:
-客户端和服务器字符集不匹配
-您使用的绑定变量的长度参数太短

还要检查以下内容: http://www.dba-oracle.com/t_ora_01460_unimplemented_or或ununreasonable_conversion_requested.htm [ ^ ]

There could be several reasons for this. For example:
- the client and the server character sets do not match
- you''re using a bind variable which has too short length parameter

Also check this: http://www.dba-oracle.com/t_ora_01460_unimplemented_or_unreasonable_conversion_requested.htm[^]

这篇关于Oracle和VB.NET中的XMLType的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！