My Oracle Support Banner

ORA-01858: a non-numeric character was found where a numeric was expected (Doc ID 2121603.1)

Last updated on DECEMBER 23, 2019

Applies to:

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

Symptoms

Replicat is abending with the following:


  Oracle GoldenGate Delivery for Oracle
  Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO
 Solaris, sparc, 64bit (optimized), Oracle 11g on Aug 8 2014 06:54:40


REPLICAT <replicat_name>
USERID <user_id>, PASSWORD *********
ASSUMETARGETDEFS
SETENV (NLS_LANG="AMERICAN_AMERICA.WE8MSWIN1252")

2016-03-25 16:19:58 INFO OGG-02095 Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252.
DBOPTIONS NOSUPPRESSTRIGGERS
DDLERROR DEFAULT IGNORE
DDL INCLUDE MAPPED OBJNAME <obj_name>
DISCARDFILE <path>/<replicat_name>.dsc, PURGE, MEGABYTES 100
MAP <table_name>, TARGET<table_name>;
MAP <table_name>, TARGET <table_name>;
MAP <table_name>, TARGET <table_name>;


2016-03-25 16:20:37 WARNING OGG-01154 SQL error 1858 mapping <table_name> to <table_name> OCI Error ORA-01858: a non-numeric character was found where a numeric was expected
ORA-06512: at "<table_name>", line 8
ORA-04088: error during execution of trigger '<table_name>' (status = 1858), SQL .



NOTE: On the target side they have a trigger that fires on changes to alertlog and populates an audit table ( alertlog_audit).

Cause

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
Symptoms
Cause
Solution


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