Oracle Error PLW-07205: SIMPLE_INTEGER is mixed with BINARY_INTEGER or PLS_INTEGER

Oracle Error Message

PLW-07205: SIMPLE_INTEGER is mixed with BINARY_INTEGER or PLS_INTEGER

Reason for the Error

Using SIMPLE_INTEGER and BINARY_INTEGER or PLS_INTEGER arguments in the same arithmetic expression may inhibit certain optimizations.

Solution

Try using SIMPLE_INTEGER values only if the expression is computed on a performance critical path.