Expert Oracle PL/SQL

Appendix B. Oracle Text Supplied Packages

The user CTXSYS owns the built-in packages listed in this appendix. CTXSYS is created during database configuration when the Oracle Text option is selected for installation. In order to use them, EXECUTE permissions must be granted to your user. This list is based on the version 10.1.0.2.0 of the Context dictionary. To determine the version you have, run the following from the CTXSYS schema.

conn ctxsys/<<password>>

SELECT *
  FROM ctx_version;

VER_DICT   VER_CODE
---------- -------------
10.1.0.2.0 10.1.0.2.0

Package Creation

When Oracle Text is selected as an option during database configuration, the CTXSYS schema and supplied packages are created automatically. Nothing needs to be done manually to create the ...