Problem solve Get help with specific problems with your technologies, process and projects.

Creating XML CLOBs on Oracle 8i

What is the best way to process or create XML CLOBs on Oracle 8i server?

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

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.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.