GoldenGate Integrated Replicat Abends: 904-ORA-00904: "UTL_RAW"."LENGTH": invalid identifier) (Doc ID 2057243.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 12.1.2.1.2 and later
Information in this document applies to any platform.

Symptoms

Integrated replicat abends with below error message.

ERROR OGG-00665 OCI Error describe for query (status = 904-ORA-00904: "UTL_RAW"."LENGTH": invalid identifier),
SQL<select source_transaction_id, message_number, error_message, (case when (bitand(flags, 1) = 1) then 'EAGER ERROR'
when (bitand(flags, 8) = 8) then (case when (bitand(flags, 2) = 2) then 'DISCARD'
else 'TRANSDISCARD' end) else 'UNHANDLED ERROR' end), utl_raw.cast_to_varchar2(external_source_po
s), start_seq#, start_rba, error_seq#, error_rba from sys."_DBA_APPLY_ERROR" where apply# = :apnum order by utl_raw.length
(external_source_pos), external_source_pos>.



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