How to fix the Oracle error ORA-01743: only pure functions can be indexed?

In this post, you’ll learn more about the Oracle ErrorORA-01743: only pure functions can be indexed with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-01743: only pure functions can be indexed

Reason for the Error ORA-01743: only pure functions can be indexed

The indexed function uses SYSDATE or the user environment.

How to fix the Error ORA-01743: only pure functions can be indexed ?

You can fix this error in Oracle by following the below steps

PL/SQL functions must be pure (RNDS, RNPS, WNDS, WNPS). SQL expressions must not use SYSDATE, USER, USERENV(), or anything else dependent on the session state. NLS-dependent functions are OK.