XMLType in Oracle and VB.NET

Question

0.00/5 (No votes)

See more:

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)

- 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);

- 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.

Posted 9-Sep-11 0:21am

szataniel

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2011-09-09T09:07:00

Solution 1

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[^]

Posted 9-Sep-11 9:07am

Wendelius

Comments

szataniel 11-Sep-11 15:03pm

Thanks for Your answer. But:
- I've read tips from link many times before I posted quastion here :) - and double checked everything ofcourse :)
- "the client and the server character sets do not match" - it's impossible, because short XMLs are transfering correctly
- "you're using a bind variable which has too short length parameter" - the most posiible reason, but which variable can I use? XML is transfered to string defined on the server app., and later this string is sent to LONG datatype on Oracle... Have You any idea where could be issue?
I had similiar problem with CRL and SQL Server, but there answer was simple. I've tried the same, but doesn't work. :(