File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes XML and Related Technologies and the fly likes CLOB / XML in Oracle DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "CLOB / XML in Oracle DB" Watch "CLOB / XML in Oracle DB" New topic

CLOB / XML in Oracle DB

Ibrahim Siddiqui1

Joined: Oct 25, 2000
Posts: 2
it would be great if some can help me in solving the following problem.
I wanted to store xml form into oracle database as a whole(nclob data type) and I wanted to apply style sheet to the xml document after retrieving from data base. I am using java servlets,javawebserver2.0. and oracle 8i database. can any one help me???
Carl Trusiak

Joined: Jun 13, 2000
Posts: 3340
CLOB is a new datatype available in jdk1.2+. It's fairly straight forward the only requirement is that your jdbc driver has to be comply with the standards for 1.2. Oracle now has a 1.2 compliant driver and you can obtain it at
Hope this helps

I Hope This Helps
Carl Trusiak, SCJP2, SCWCD
Sameer Rao

Joined: Oct 12, 2000
Posts: 20
Hi ,
Oracle8i has BLOB, CLOB and BFILE datatypes. What you mentioned as nCLOB, isnt it the same as CLOB or there is still some difference between the two.


I agree. Here's the link:
subject: CLOB / XML in Oracle DB
It's not a secret anymore!