Hexagon Geospatial
MENU

GeoMedia Smart Client

GeoMedia Smart Client community discussion board is where you can create, contribute and share information and knowledge in regards to configuring as well as working with GeoMedia Smart Client. Find your answers, share your knowledge and help build a strong GeoMedia Smart Client community.
Showing results for 
Search instead for 
Do you mean 
Reply
Occasional Contributor
Posts: 18
Registered: ‎10-19-2015
Accepted Solution

FullTextIndex on Oracle

Hi

 

Did anybody implement a public maps search using an oracle data source? There is a manual in the wiki how to create full text index in oracle, but we don't succeed. Does anybody have a sample script? Should it also work with oracle express?

 

Thanks & regards

Carmen

Staff
Posts: 963
Registered: ‎10-19-2015

Re: FullTextIndex on Oracle

Hi Carmen,

 

here is an example.

 

--Creation of preference for custom LEXER
BEGIN
  ctx_ddl.create_preference(
    preference_name => 'MCNO_LEXER',
    object_name     => 'BASIC_LEXER'
  );
  -- turn off MIXED_CASE
  ctx_ddl.set_attribute(
    preference_name => 'MCNO_LEXER',
    attribute_name  => 'MIXED_CASE',
    attribute_value => 'NO'
  );
END;
-- create preference with list of columns to search on
BEGIN
ctx_ddl.drop_preference ('HOTELXXPREF');
ctx_ddl.create_preference('HOTELXXPREF', 'MULTI_COLUMN_DATASTORE');
ctx_ddl.set_attribute('HOTELXXPREF', 'COLUMNS', 'FAC_NAME,FAC_ADD,NAME');
END;
-- this is a dummy column to be used in the index creation
alter table HOTEL_X_X add SearchColumn varchar2(1);
--Creation of text index with sync parameter
drop index HOTEL_X_X_FTIDX force;
CREATE INDEX HOTEL_X_X_FTIDX
ON HOTEL_X_X(SearchColumn)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS ('DATASTORE HOTELXXPREF SYNC (ON COMMIT) LEXER MCNO_LEXER');

HTH,

ciao.

Stefano

Stefano Turcato
Presale Engineer
Hexagon Geospatial
Occasional Contributor
Posts: 18
Registered: ‎10-19-2015

Re: FullTextIndex on Oracle

Grazie mille Smiley Very Happy

 

Regards

Carmen

Staff
Posts: 963
Registered: ‎10-19-2015

Re: FullTextIndex on Oracle

Non c'è di che! Smiley Happy

 

ciao,

Stefano

Stefano Turcato
Presale Engineer
Hexagon Geospatial
Do you need immediate support?
If you encounter a critical issue and need immediate assistance please submit a Service Request through our Support Portal.