Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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?

Thanks in advance!

Comments

Herald ten Dam
Hi,

welcome.

The user who made the index, does it have the role CTXAPP? Otherwise you need to grant this role to the user. 
grant CTXAPP to your_user;
Otherwise you need explicitly grant execute rights of the package CTX_DOC to this user.
The owner of the package is CTXSYS. 
grant execute on ctxsys.ctx_doc to your_user;
If there are still problems, it will be better to post in the TEXT forum.

Herald ten Dam
htendam.wordpress.com
776964
Unfortunately, that doesn't seem to work either:

grant execute on ctxsys.ctx_doc to sysadm
*
FOUT in regel 1:
.ORA-04042: procedure, function, package, or package body does not exist

Thanks for your reply. I will continue this in the right forum.
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 1 2010
Added on Jun 3 2010
#9i, #filter, #oracle, #text
2 comments
838 views