Oracle Error PLS-00624: USING clause must be used with either aggregate or pipelined functions

Oracle Error Message

PLS-00624: USING clause must be used with either aggregate or pipelined functions

Reason for the Error

USING clause cannot be used with functions that are not declared with AGGREGATE or PIPELINED properties.

Solution

Define function body in PL/SQL or some other language (using external callout call specification).