SQL Functions - Oracle Documentation

Do not confuse SQL functions with user-defined functions written in PL/SQL. If you call a SQL function with an argument of a datatype other than the datatype ...

docs.oracle.com