How to fix the Oracle error PLS-00420: can’t call builtin routines remotely?

In this post, you’ll learn more about the Oracle ErrorPLS-00420: can’t call builtin routines remotely with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

PLS-00420: can’t call builtin routines remotely

Reason for the Error PLS-00420: can’t call builtin routines remotely

An attempt was made to call a built-in PL/SQL function remotely, which is not allowed. For example, the code might look like my_sqlerrm := SQLERRM@newyork; or INSERT INTO emp VALUES (my_empno, STANDARD.RTRIM@newyork(my_ename), …);

How to fix the Error PLS-00420: can’t call builtin routines remotely ?

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

Always call built-in functions locally; never specify a database link.