I want to create a script to create an Index set and then create an Index to use the CatSearch. However I cant get it to run using my plsql. I can create the index using the script but cant create the index set as it cant find the procedure. However I,m using toad and when I type in CTXSYS and a dot it gives me up a list of the procedures. I select the Create_Index_Set but when I run it it can find it. Do I need roles or rights to see this....or what am I doing wrong. thanks Mick
Heres my script if you could look at it....
EXECUTE IMMEDIATE 'CTXSYS.CREATE_INDEX_SET ''IDXSET_RECKEYWDDATEDESC'')';
Ive also tried CTXSYS.CTX_DLL.Create_Index_set and CTX_DLL.Create_Index_set inside the execute but cant get it to run.
I can create the index alright but not the index -set. I,m using Toad again. I,ve also tried using quotes around the statement and without them. Any ideas
Heres how I create the index
Execute immediate ('CREATE INDEX IDX_REC_KEYWD_DATE_DESC ON MyTable (Keywords) INDEXTYPE IS CTXSYS.CTXCAT');