Oracle/PLSQL: ORA-00900 Error

Error Message

ORA-00900: invalid SQL statement

Cause of Error

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

Resolution

The option(s) to resolve this Oracle error are:

Option #1

This error commonly occurs when you are trying to create an Oracle 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: