OraFAQ Forum: Text & interMedia » CTX

Home » Server Options » Text & interMedia » CTX_DOC (Oracle Text)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CTX_DOC [message #398953]

Mon, 20 April 2009 00:23

estola
Messages: 3
Registered: April 2009

Junior Member

I apologize if this is a stupid question but it has been frustrating me for a long time. I am using the Oracle Text search engine. I need to retrieve a marked up version of a document based on a query, however when I try to run ctx_doc.markup I recieve an Invalid Identifier error. What really confuses me is that I can use ctx_doc.snippet just fine.

Thanks for any help,
Evan

Report message to a moderator

Re: CTX_DOC [message #399117 is a reply to message #398953]

Mon, 20 April 2009 13:41

Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA

Senior Member

Please post a copy and paste of a run of what you did, that includes line numbers and complete error message.

[Updated on: Mon, 20 April 2009 13:42]

Report message to a moderator

Re: CTX_DOC [message #399150 is a reply to message #399117]

Mon, 20 April 2009 22:40

estola
Messages: 3
Registered: April 2009

Junior Member

It happens whenever I run ctx_doc.markup. The error I recieve is:

Exception in thread "main" java.sql.SQLException: ORA-00904: "CTX_DOC"."MARKUP": invalid identifier

(I am running this from java currently but I receive a similar error when I run it from sqlplus as well)

Report message to a moderator

Re: CTX_DOC [message #399156 is a reply to message #399150]

Mon, 20 April 2009 23:14

Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA

Senior Member

Obviously you are doing something wrong, since it works for me. If you are not willing to post what you did, so that I can see what you did wrong, I am not going to guess at what you might have done. I suggest that you review the forum guidelines that are available at the top of every forum, highlighted in yellow, for how to post a proper question, in order to enable us to help you. Here is a link to the forum guide:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: CTX_DOC [message #399157 is a reply to message #399150]

Mon, 20 April 2009 23:17

Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA

Senior Member

I will take a guess. Since it does not seem to recognize ctx_doc.markup, it is probably a privilege issue. If it works from an anonymous pl/sql block, but not from a stored procedure, then that would confirm it. Procedures do not recognize privileges granted through roles, so you would need execute privileges granted explicity on the ctx_doc package.

[Updated on: Mon, 20 April 2009 23:17]

Report message to a moderator

Previous Topic:	How to prevent SQL Injection in OracleText SQL statement
Next Topic:	Help with a CONTEXT index

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 18:46:49 CST 2025