Resolve ORA-00900 Error Message in Oracle

Learn the purpose and how to unravel the ORA-00900 error message in Oracle.

Description

When you encounter an ORA-00900 error, the following error message will appear:

ORA-00900: invalid SQL statement

Cause

The statement that you have tried to execute is not a legitimate SQL statement.

Resolution

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

Option #1

This error frequently happens when you are trying to create an Oracle technique and the Procedural Option is now not installed.

To decide if the Procedural Option has been installed, open an Oracle session using SQL*Plus. If the PL/SQL banner does no longer display, then you recognize that the Procedural Option has no longer been installed.

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