Re: Oracle context

Sounds like your initialization file is missing the EXTPROC entry. The best info I've found on setting up ConText / interMedia Text / Text is on OTN.oracle.com, at:

http://otn.oracle.com/products/text/x/Tech_Overviews/imt_815.html

John

On 18 Feb 2002 18:09:17 -0800, dbpchary_at_hotmail.com (Chary) wrote:

>thanks for the response.
>
>What u suggested me is for security.
>But what I wanted is to use 'contains' keyword in sql statement.
>i.e select empid from employee where contains(ename,'ddd') > 0.
>For this what i have done is I have created a index on ename column
>with indextype ctxsys.context.But it is giving following error.
>
>The following error has occurred:
>
>ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
>ORA-20000: interMedia Text error:
>DRG-50704: Net8 listener is not running or cannot start external
>procedures
>ORA-28575: unable to open RPC connection to external procedure agent
>ORA-06512: at "CTXSYS.DRUE", line 126
>ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 54
>ORA-06512: at line 1
>
>Net8 listener is running.What might be the problem?
>
>thanks,
>Chary
>
>
>
>"Sergey M" <msu_at_pronto.msk.ru> wrote in message news:<a4qgpi$r4d$1_at_serv2.vsi.ru>...
>> "Chary" <dbpchary_at_hotmail.com> wrote in message
>> news:eb8a3dc8.0202172331.4939a9fe_at_posting.google.com...
>> > I am using oracle8.1.6.
>> > If I want to use context do I need to start context server.
>> > If anyone has done it before please help me in doing this.
>>
>> If you want use oracle context, you need to create context
>> (see "SQL Reference" CREATE CONTEXT and "Oracle8i Application Developer's
>> Guide - Fundamentals " Chapter 11) and You no need to start context server.
>>
>> Sergey M.

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/