Home » Server Options » Text & interMedia » CTX_DOC (Oracle Text)
CTX_DOC [message #398953] Mon, 20 April 2009 00:23 Go to next message
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
Re: CTX_DOC [message #399117 is a reply to message #398953] Mon, 20 April 2009 13:41 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
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 Go to previous messageGo to next message
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)
Re: CTX_DOC [message #399156 is a reply to message #399150] Mon, 20 April 2009 23:14 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9077
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/
Re: CTX_DOC [message #399157 is a reply to message #399150] Mon, 20 April 2009 23:17 Go to previous message
Barbara Boehmer
Messages: 9077
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:
  


Current Time: Thu Mar 28 03:30:00 CDT 2024