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-32107: internal OCI memory allocation failure

1 Answers  


TNS-12529: TNS:connect request rejected based on current filtering rules

1 Answers  


ORA-07481: snlmatt: cannot attach to lock manager instance.

1 Answers  


PROC-00032: Cluster Ready Services on the local node is not running

1 Answers  


QSM-01079: DML operation occurred on a table referenced by MV, string

1 Answers  


KUP-03006: error initializing handle for character set string

1 Answers  


ORA-23453: requested operation is not supported on top flavor

1 Answers  


ORA-29892: indextypes with array DML do not support the given data type

1 Answers  


TNS-02518: key negotiation error

1 Answers  


RMAN-02005: token too big

2 Answers  


NID-00442: Database has been shutdown, open database with RESETLOGS option.

1 Answers  


IMG-00542: contentFormat includes invalid extra information

1 Answers  


Categories