Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00392: Type mismatch in arguments to BETWEEN
- 2 Answers
- 4452 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
Cause: In a comparison such as X BETWEEN Y AND Z, the
expressions X, Y, and Z do not match in datatype, and it is
unclear which implicit conversion is required to correct the
mismatch.
Action: Change the expressions so that their datatypes
match. You might want to use datatype conversion functions.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / atul tandon
This error appears when any variable differs in data type
i.e suppose one is numeric and the others are character
and vice versa.
| Is This Answer Correct ? | 0 Yes | 0 No |
NZE-29227: Certificate is expired.
ORA-01314: Name of the column to be mined should be a string literal
PCC-00053: FOR variable string is invalid type at line number in file string
NNL-00343: Log file name is now string
IMG-00923: signature is empty
QSM-01044: join back attempted on a view for string
ORA-09312: slspool: error spooling file to printer
ORA-22341: cannot assign supertype instance to subtype
ORA-19586: %s k-byte limit is too small to hold piece directory
LPX-00601: Invalid token in: '~S'
ORA-12040: master rollback segment option not support by master site string
NNL-00853: Renames refused, new name already exists: number
Oracle Errors 
