Solved

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

Posted on 2001-08-15
5
2,249 Views
Last Modified: 2012-08-13
Hi

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?

/Brian
0
Comment
Question by:Brian_HP
  • 3
  • 2
5 Comments
 
LVL 6

Expert Comment

by:Jankovsky
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.

Bob
0
 

Author Comment

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

/Brian
0
 

Author Comment

by:Brian_HP
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?

/Brian
0
 
LVL 6

Accepted Solution

by:
Jankovsky earned 100 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.
Bob
0
 

Author Comment

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

/Brian
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
return result by latest date - oracle query 21 69
PL/SQL LOOP CURSOR 3 58
Oracle Public Synonyms and Privileges 2 51
sort a spool into file output in oracle 1 22
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

910 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now