Sample Script to Create a Text Index on Encrypted TEXT Data
(Doc ID 2443615.1)
Last updated on JUNE 23, 2023
Oracle Text - Version 188.8.131.52 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!