Re: Oracle context

From: Chary <dbpchary_at_hotmail.com>
Date: 18 Feb 2002 18:09:17 -0800
Message-ID: <eb8a3dc8.0202181809.571f82c9@posting.google.com>

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.
Received on Mon Feb 18 2002 - 20:09:17 CST