Oracle/PLSQL: ORA-00919 Error

Error:

ORA-00919: invalid function

Cause:

You tried to call a function, but the name you used was not a valid Oracle function.

Action:

The options to resolve this Oracle error are:

Correct the spelling of the Oracle function that you wish to call.

For a complete listing of Oracle functions, go to our Oracle functions webpage.

Try using the dual table if you wish to call a function without querying a table.

For example, if you had created a custom function called TestFunction and you wanted to call this function, you could try the following:

SELECT TestFunction()
FROM dual;