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-25254: time-out in LISTEN while waiting for a message

1 Answers  


NNL-00346: Save_config_on_stop is now ON

1 Answers  


KUP-04017: OS message: string

1 Answers  


PCC-02325: illegal indirection operation

1 Answers  


ORA-27488: unable to set string because string was/were already set

1 Answers  






NNL-00803: Queries received, type ALIAS: number

1 Answers  


ORA-22857: cannot modify columns of object tables

1 Answers  


ORA-00166: remote/local nesting level is too deep

1 Answers  


NZE-29116: Cannot get PKCS #12 attributes.

1 Answers  


ORA-19671: media management software returned invalid proxy handle

1 Answers  


ORA-13830: SQL profile with category string already exists for this SQL statement

1 Answers  


ORA-26003: parallel load not supported for index-organized table string.

1 Answers  


Categories