Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

CLOB / XML in Oracle DB

 
Ibrahim Siddiqui1
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
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???
Thanks.
 
Carl Trusiak
Sheriff
Posts: 3341
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 http://technet.oracle.com/software/tech/java/sqlj_jdbc/software_index.htm
Hope this helps
 
Sameer Rao
Greenhorn
Posts: 20
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.

------------------
_SvR_
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic