Skip to Main Content

Unable to use ctx_doc despite Oracle Text installation

776964Jun 3 2010 — edited Jun 3 2010
Hi,

We're using Oracle 9iR2.
I'm in need to convert a Long Raw column to readable text. I've managed to convert it to CLOB and it now gives me an RTF encoded string.

I've read on several forums that this RTF string can be converted to readable text using the CTX_DOC.FILTER or CTX_DOC.IFILTER functions. But despite Oracle Text 9.2.0.1.0 being successfully installed (by OUI), there ain't any CTX_DOC packages. I'm getting the error:

"PLS-00201: identifier 'CTX_DOC.IFILTER' must be declared".

Even running as database administrator, I'm not able to run this function.

Can anyone help us in making this work? I've posted in the wrong forum before (PL/SQL) but their tips didn't work: 1083441

Thanks in advance!
Comments
Post Details
Added on Jun 3 2010
1 comment
1,259 views