My Oracle Support Banner

Sample Script to Create a Text Index on Encrypted TEXT Data (Doc ID 2443615.1)

Last updated on JUNE 23, 2023

Applies to:

Oracle Text - Version and later
Information in this document applies to any platform.


Oracle Text does not support directly indexing encrypted TEXTt data in BLOB columns. This sample script shows how to use a user-defined procedure via the USER_DATASTORE to decrypt the encrypted BLOB, and effectively index it using NULL_FILTER.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 Sample Code
 Sample Output

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.