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>
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