O'Reilly logo

Expert Oracle PL/SQL by Michael McLaughlin, Ron Hardman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required