tech on the net
Home About Us Feedback Site Map


Access Excel Word


SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker


C Language


ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

Oracle/PLSQL: ORA-00900

Learn the cause and how to resolve the ORA-00900 error message in Oracle.


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

  • ORA-00900: invalid SQL statement


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


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:

Oracle PLSQL