Oracle/PLSQL: ORA-00900 Error

Error:

ORA-00900: invalid SQL statement

Cause:

The statement that you've tried to execute is not a valid SQL statement.

Action:

The options to resolve this Oracle error are:

This error commonly occurs when you are trying to create a procedure and the Procedural Option is not installed.

To determine if the Procedural Option has been installed, open an Oracle session using SQL*Plus. If the PL/SQL banner does not display, then you know that the Procedural Option has not been installed.

Below is what a sample PL/SQL banner looks like: