RE: Indexing CLOB Column in Oracle

2010-03-17 Thread Craig Christman
Subject: Re: Indexing CLOB Column in Oracle Disclaimer: My Oracle experience is miniscule at best. I am also a beginner at Solr, so grab yourself the proverbial grain of salt. I googled a bit on CLOB. One page I found mentioned setting up a view to return the data type you want. Can you use

Re: Indexing CLOB Column in Oracle

2010-03-17 Thread Lance Norskog
...@caci.com] Sent: Wednesday, March 17, 2010 11:23 AM To: solr-user@lucene.apache.org Subject: RE: Indexing CLOB Column in Oracle To convert an XMLTYPE to CLOB use the getClobVal() method like this: SELECT d.XML.getClobVal() FROM DOC d WHERE d.ARCHIVE_ID = '${doc.ARCHIVE_ID}' -Original Message

Re: Indexing CLOB Column in Oracle

2010-03-16 Thread Shawn Heisey
Disclaimer: My Oracle experience is miniscule at best. I am also a beginner at Solr, so grab yourself the proverbial grain of salt. I googled a bit on CLOB. One page I found mentioned setting up a view to return the data type you want. Can you use the functions described on these pages in