|
XML CLOBs will be stored in a table with the CLOB datatype. It doesn't make
a difference if the CLOB is XML, or a large text document, or whatever large
character object you want to store in a table. To handle CLOBs, or any other
large objects, I suggest that you read a copy of the Oracle8i Application
Developer's Guide - Large Objects (LOBs) documentation. You can view a copy
on Technet.
It goes over various development platforms (such as VB) and how to handle
LOBs.
Continued May 24th, 2001...
Kesavan,
Your original question was "What is the best way to process or create XML
CLOBs on Oracle 8i server?". This was a pretty generic question itself and
without knowing exactly what you are looking for, I was left with only
giving you a generic answer. I will attempt to give you a little more
detail. But if I fail to provide the answer that you seek, then I would like
you to provide me with more specific information that you are looking for.
According to the Oracle documentation, there are various application
platforms that you can use for LOBs. They are PL/SQL (with the DBMS_LOB
package), C (through OCI), C (through Pro*C), COBOL (through Pro*Cobol), VB
(through OLE), and Java (through JDBC). Which platform you choose depends on
a variety of things that really have nothing to do with LOBs.
Which platform are you most familiar with? Most companies develop on a
specific platform because that is where their expertise lies. Some develop
on a specific platform because they want to harness the benefits of that
development platform. For example, if I want my application to be portable,
I'd use Java.
Once you've settled on a platform, there is really only one way to handle a
LOB for that development platform. For instance, if I'm using C through OCI
and I want to read a LOB, I need to use the OCILobRead() procedure.
That being said, the only other thing I can think of has to do with speed.
If speed is an issue, then PL/SQL and C through OCI "should" be faster than
the rest. I say that it should because that may not always be the case. Your
mileage may vary.
I hope that I've answered your question a little better this time.
For More Information
|
