PLS-00392: Type mismatch in arguments to BETWEEN
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 |
PCB-00500: No EXEC SQL CONTEXT USE statement encountered
DRG-13305: 'off' attribute value must be in the range string..string, at line string
PCC-02105: Unable to open list file
DRG-50913: first document requested string is not a positive number
QSM-00795: the SQL Tuning Set repository has not been implemented
TNS-12689: Server Authentication required, but not supported
ORA-15169: destination 'string' is a subdirectory of 'string'
NNL-00800: Query requests received: number
ORA-16056: backup control file archival requires proper syntax
ORA-25306: Queue table string has buffered queues. Cannot alter
ORA-04095: trigger 'string' already exists on another table, cannot replace it
ORA-07655: slsprom:$TRNLOG failure