ORA-01858: a non-numeric character was found where a numeric
was expected



ORA-01858: a non-numeric character was found where a numeric was expected..

Answer / guest

Cause: The input data to be converted using a date format
model was incorrect. The input data did not contain a number
where a number was required by the format model.

Action: Fix the input data or the date format model to make
sure the elements match in number and type. Then retry the
operation.

Please add more information about this Error

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-06111: NETTCP: disconnect failure

1 Answers  


NNL-00412: Number of requests: number

1 Answers  


TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter from SID_DESC

1 Answers  


ORA-01326: compatability of 9.0 or greater required to build into the logstream

1 Answers  


SQL*Loader-00127: Invalid maximum record size

1 Answers  






ORA-39025: jobs of type string are not restartable

1 Answers  


QSM-02126: no rowid at master site

1 Answers  


PCC-00015: Unrecognized Host Language syntax ignored at line number in file string

1 Answers  


ORA-15034: disk 'string' does not require the FORCE option

1 Answers  


RMAN-06194: target database instance not started

1 Answers  


DRG-51313: timeout while waiting for DML or optimize lock

1 Answers  


ORA-28025: missing or null external name

1 Answers  


Categories