ORA-01859: a non-alphabetic character was found where an
alphabetic was expected



ORA-01859: a non-alphabetic character was found where an alphabetic 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 letter
where a letter 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 ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

TNS-00134: Missing COMMUNITY component in addresses for the Navigator in TNSNAV.ORA

1 Answers  


ORA-06041: NETDNT: disconnect failed

1 Answers  


ORA-25103: NOPARALLEL option can only be used with ALTER INDEX REBUILD

1 Answers  


ORA-08465: input mask contains more than 32 characters

1 Answers  


ORA-38414: invalid datatype for the attribute string

1 Answers  






NPL-00309: requested ASN.1 type tag string does not match received type tag string

1 Answers  


TNS-04234: Trace Assistant WARNING: won't decode TTC

1 Answers  


SQL*Loader-00133: Can't specify both direct path and external tables

1 Answers  


DRG-50851: SQL execute failed

1 Answers  


PLS-00146: duplicate external TRUSTED/UNTRUSTED specification in subprogram expression

1 Answers  


PLS-00568: cannot access rows from a non-nested table item

1 Answers  


ORA-25350: maximum number of concurrent transaction branches exceeded

1 Answers  


Categories