In this post, you’ll learn more about the Oracle ErrorPLW-07205: SIMPLE_INTEGER is mixed with BINARY_INTEGER or PLS_INTEGER with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
PLW-07205: SIMPLE_INTEGER is mixed with BINARY_INTEGER or PLS_INTEGER
Reason for the Error PLW-07205: SIMPLE_INTEGER is mixed with BINARY_INTEGER or PLS_INTEGER
Using SIMPLE_INTEGER and BINARY_INTEGER or PLS_INTEGER arguments in the same arithmetic expression may inhibit certain optimizations.
How to fix the Error PLW-07205: SIMPLE_INTEGER is mixed with BINARY_INTEGER or PLS_INTEGER ?
You can fix this error in Oracle by following the below steps
Try using SIMPLE_INTEGER values only if the expression is computed on a performance critical path.