ORA-40499 : No Format Defined For Binary Data Type (Doc ID 2299865.1)

Last updated on AUGUST 22, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.2.0.1 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

The following error can occur when an Oracle Text query is using json_textcontains()

ORA-40499 : no format defined for binary data type

An example of a text query using json_textcontains() would be:

SELECT * FROM APPLICATION  WHERE json_textcontains(APPLICATION, '$', 'test')

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms