Here is a really easy fix for some ORA-00900 errors. Well at least the one I saw the other day. This was something that I did not come across when searching either. I found lots of other ideas on what the problem might be but not the fix. Since I am fairly new to PL/SQL (TSQL only for a long time) this one stumped me for a while. Until I asked someone and they saw the error in about two seconds.

Error ORA-00900 occurs when the user tries to execute a statement that is not a valid SQL statement. This error occurs if the Procedural Option is not installed and a SQL statement is issued that requires this option. Users have several options in resolving error ORA-00900. I add an oracle store procedure to OLE DB Command. This store procedure works at oracle db. However, in SSIS, it shows error:ORA-00900 Error: 0xC0047022, SSIS error. ORA-00900: invalid SQL statement ORA-00901: invalid CREATE command ORA-00902: invalid datatype ORA-00903: invalid table name ORA-00904: string: invalid identifier ORA-00905: missing keyword.

When using the Command Window to add a view I was receiving an ORA-00900 error. So I checked that everything the view was referencing was there and that the permissions looked OK. The code for the view was fairly simple and it ran just fine in a regular SQL Window. It ended up that the Command Window did not like the space I had between the list of items in the select before the from.

Bad:

col1,
col2,
<--- does not like the empty line
from tblSomething

Good:

col1,
col2,
from tblSomething

I will just chalk that up to my familiarity with PL/SQL.

Tags: PLSQL

Posted on Friday, April 13, 2012 4:25 PM | Back to top

Last updated on DECEMBER 19, 2019

Applies to:

PL/SQL - Version 11.2.0.4 and later
Generic (Platform Independent)

Ora 00920

Symptoms

EXECUTE IMMEDIATE failed when calling PL/SQL object:

Changes

Ora-00900 Invalid Sql Statement C#

None

Cause

Ora-00900 Invalid Sql Statement Insert

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

Changes

Ora 900

Cause

Ora 20900

Solution

Ora 00900 Error

References

Oracle Ora 00904 Invalid Identifier

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.