On Mon, Jun 05, 2000 at 10:53:53PM -0800, Swajit Satam wrote:
> Hi All,
>
> 1. ) I am having the following Table and I want to do a Intermedia
> search on it
>
> SQL> desc multi_tab
>
> Name Null? Type
> ------------------------------- -------- ----
> IMG BINARY
> FILE LOB
> A NOT NULL NUMBER
>
> 2. ) the data present in the table
>
> SQL> select DBMS_LOB.GETLENGTH(IMG),a from multi_tab ;
>
> DBMS_LOB.GETLENGTH(IMG) A
> ----------------------- ---------
> 10 2
> 18 3
> 14 1
>
> 3. ) For Search I executed the following Query
>
> SELECT SCORE(1) title from multi_tab
> WHERE CONTAINS(IMG, 'oracle', 1) > 0;
>
> 4. ) I get the following Error
>
> ERROR at line 1:
> ORA-20000: ConText error:
> DRG-10599: column is not indexed
>
> So I gave a Create Index Syntax
> It gives a following error
>
> create index testindex on multi_tab(IMG) indextype is ctxsys.context
> *
> ERROR at line 1:
> ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
> ORA-20000: ConText 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 122
> ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 34
> ORA-06512: at line 1
>
> I have Also Configuring Net8 for External Procedures
> by editing the LISTENER.ORA and TNSNAMES.ORA accordingly
> but still it gives the same error
What is the "lnsrctl start" output ? Is the extproc service
Received on Tue Jun 06 2000 - 02:54:35 CDT
