My Oracle Support Banner

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

Last updated on APRIL 01, 2020

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1 to 12.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
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')


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

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