Oracle Solution for Error ora-29977

ORA-29977: Unsupported column type for query registration in guaranteed mode

What triggered the Error:

An attempt was made to register a query with an unsupported column type or too many columns.

What should we do to fix it:

Examine all column datatypes in the expression and refer to the documentation for supported query types. The application can reattempt the query registration in best effort mode.