PLS-00201: identifier 'CTX_THES' must be declared, while creating thesaurus [message #547254] |
Tue, 13 March 2012 10:27 |
|
tristran
Messages: 3 Registered: January 2012
|
Junior Member |
|
|
I need to create a subject specific thesaurus in oracle text for a project at my university. Since the database is maintained by another university and the admins there never had users who needed the oracle text features, we try to be as specific as possible with requests. So I installed a local version of oracle 11g XE to test everything beforehand. Once I thought I knew what I needed I asked them for additional roles (CTXAPP, most importantly) and tried the same, I had done locally:
begin
ctx_thes.create_thesaurus(
name => 'FORESTTHESAURUS',
casesens => false
);
end;
/
Unfortunately I got this:
SQL> begin
ctx_thes.create_thesaurus(
name => 'FORESTTHESAURUS',
casesens => false
);
end;
/ 2 3 4 5 6 7
ctx_thes.create_thesaurus(
*
ERROR at line 2:
ORA-06550: line 2, column 3:
PLS-00201: identifier 'CTX_THES' must be declared
ORA-06550: line 2, column 3:
PL/SQL: Statement ignored
And now I am slightly confused, why CTX_THES must be declared. Any hints would be welcome.
|
|
|
|
|
|
|
|
|
Re: PLS-00201: identifier 'CTX_THES' must be declared, while creating thesaurus [message #547771 is a reply to message #547548] |
Fri, 16 March 2012 08:00 |
|
tristran
Messages: 3 Registered: January 2012
|
Junior Member |
|
|
@Barbara Boehmer
Yes, you can use CTX_THES to specify a user defined thesaurus. So the limited functionality is there. I didn't try to use the knowledge base functions, so I never realised that so many features are missing. Thanks for the advice.
As for the main question, I'll contact the dbas for the production database. Thank you very much for your and Michels advice in this area as well.
|
|
|