[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Making/using e.g. the CTX_DDL package available ?

Posted on 2001-08-15
Medium Priority
Last Modified: 2012-08-13

I am trying to use the CTX_DDL package - but I cannot get it to work in SQL*Plus.

I have tried e.g.:

SQL> begin
  2  ctx_ddl.crate_preference('STEM_FUZZY_PREF', 'BASIC_WORDLIST');
  3  end;
  4  /
ctx_ddl.crate_preference('STEM_FUZZY_PREF', 'BASIC_WORDLIST');
ERROR at line 2:
ORA-06550: line 2, column 1:
PLS-00201: identifier 'CTX_DDL.CRATE_PREFERENCE' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored

I don't know much about Oracle, but I know even less about packages.  How do I make e.g. the CTX_DDL package available?

Question by:Brian_HP
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2

Expert Comment

ID: 6387925
Check presence of InterMedia (or ConText) cartridge installed on Oracle Server and enabled in deatabase instance. CTX.. packages arent default implemented on Oracle server.


Author Comment

ID: 6387968
How do I check whether the InterMedia (or ConText) is present on the Oracle Server - and whether it is enabled?


Author Comment

ID: 6388007
I have tried to see the installed packages with DBA Studio, and InterMedia or ConText was not present.  How do I make them present?


Accepted Solution

Jankovsky earned 400 total points
ID: 6388048
1.Start up the Oracle Database Configuration Assistant by executing dbassist
2.Select [Modify Database].
3.Slect the appropriate database SID from the list of those detected.
4.Choose the options you wish to enable from the list.
5.Click the [Finish] button.

More You can see in Oracle Installation Guide.

Author Comment

ID: 6388181
Thank you very much!  You solved my problem.  I can now use e.g. the CTX_DDL package ...


Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question