XML handling in Oracle

0.00/5 (No votes)

See more:

I have a XML file of 100KB(the file size can increase).I am passing this as an XML document to a sp in oracle.The datatype used in the sp to recieve this is Clob.
The time taken for this document to reach the sp parameter is 10 sec.This is a considerable amount of time for a 100KB file.
I have to improve this time(reduce from 10 secs).
The sp takes only 18 milliseconds to insert the data into the tables.
The XML document is well formed with proper root element,nesting and closing tags.

What all can be done to improve the time

Posted 4-Oct-11 19:52pm

Joseph Rego

Updated 9-Oct-11 20:02pm

Add a Solution

Comments

CodingLover 10-Oct-11 2:31am

Can you show your code please?

DANAOS_master 19-Oct-11 10:25am

How many times you need this time to be improved?

What kind of language you use to call the stored procedure?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

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

Last 24hrs

This month

0x01AA	50
Jochen Arndt	40
Wendelius	20
CPallini	20
OriginalGriff	20

Pete O'Hanlon	535
OriginalGriff	260
Richard MacCutchan	165
merano99	120
KarstenK	50