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

NNL-00208: Cancelled reload check

1 Answers  


ORA-25228: timeout or end-of-fetch during message dequeue from string.string

1 Answers   HP,


ORA-24378: user callbacks not allowed for this call

1 Answers  


NID-00602: Could not allocate number bytes for "string"

1 Answers  


ORA-09770: pws_look_up: translation failure.

1 Answers  


RMAN-06903: backup of datafile string was cancelled

1 Answers  


ORA-01200: actual file size of string is smaller than correct size of string blocks

1 Answers  


ORA-13292: incorrect ARC_TOLERANCE specification

1 Answers  


NPL-00416: received illegal ASN.1 encoding length of string

1 Answers  


LPX-00236: invalid character ~1u ('~2c') found in public identifier

1 Answers  


ORA-00116: SERVICE_NAMES name is too long

1 Answers  


ORA-32831: timed out trying to acquire administration lock

1 Answers  


Categories