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 to [Release 12.1 to 12.2]
Information in this document applies to any platform.


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')


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