Re: Problems with Oracle Text (in Oracle 10g)

From: <jasondugdale_at_hotmail.co.uk>
Date: Fri, 27 Jun 2008 07:41:36 -0700 (PDT)
Message-ID: <c6705cc4-198f-4257-a9df-995623eb1ce0@i76g2000hsf.googlegroups.com>


>
> Look up CTX_DOC.HIGHLIGHT in Oracle Text Reference.
>

Hi,

I built a CTX_DOC.HIGHLIGHT operation, and inserted it at the end of my loop, but it keeps returning DRG-10011: invalid object name, and ORA-00931: missing identifier, errors. Here's what I wrote:

 CTX_DOC.SET_KEY_TYPE('PRIMARY_KEY');

     CTX_DOC.HIGHTLIGH(INDEX_NAME => 'news_index',
                                      TEXTKEY    =>
TO_CHAR(newsrec.news_id),
                                      TEXT_QUERY => p_string,
                                      RESTAB     => mklob,
                                      PLAINTEXT  => TRUE);
Received on Fri Jun 27 2008 - 09:41:36 CDT

Original text of this message