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


Don't get me started about those stupid light bulbs.
subject: CLOB / XML in Oracle DB