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...
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
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical Oracle questions--or help out your peers by answering them--in our live discussion forums.
- Ask the Experts yourself: Our Oracle gurus are waiting to answer your toughest questions.
Dig Deeper on Oracle XML
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.