Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


PLS-00392: Type mismatch in arguments to BETWEEN

Answers were Sorted based on User's Feedback



PLS-00392: Type mismatch in arguments to BETWEEN..

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

PLS-00392: Type mismatch in arguments to BETWEEN..

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

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00942: partition string not part of table string

1 Answers  


ORA-02310: exceeded maximum number of allowable columns in table

1 Answers  


ORA-23354: deferred RPC execution disabled for "string" with "string"

1 Answers  


SQL*Loader-00101: Invalid argument for username/password

1 Answers  


NZE-29031: SSL handshake is required.

1 Answers  






AMD-00112: PROCEDURE string, invalid mode

1 Answers  


ORA-19597: file string blocksize string does not match set blocksize of string

1 Answers  


ORA-01583: unable to get block size of controlfile to be backed up

1 Answers  


AMD-00144: Custom Measure "string" does not exist in Workspace "string"

1 Answers  


TNS-00231: Pump is alive

1 Answers  


ORA-02331: cannot create constraint on column of datatype string

1 Answers  


ORA-13755: invalid "SQL Tuning Set" name

1 Answers  






Categories