Top "Ora-00900" questions

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

How to execute an oracle stored procedure?

I am using oracle 10g express edition. It has a nice ui for db developers. But i am facing some …

Read More
oracle plsql oracle10g ora-00900
Problem with execute procedure in PL/SQL Developer

I this is my first attempt to create procedure and execute it. First I create simple table. DB scheme of …

Read More
sql oracle plsql procedure ora-00900
Executing stored procedure in PL/SQL Developer SQL Window

I've used TOAD for awhile, but my dept has asked me to evaluate PL/SQL Developer as a possible change. …

Read More
oracle exec procedure plsqldeveloper ora-00900
ORA-00900: invalid SQL statement error

While running dbms command execute dbms_utility.analyze_schema('MCC','ESTIMATE',30); I got ORA-00900: invalid SQL statement error. Can anyone …

Read More
oracle ora-00900
Oracle PLS-00103 error. How do you check for an existing record and do update or insert based on that condition?

I need to check if a record exists in the table or not from a SELECT statement. If the record …

Read More
sql oracle plsql upsert ora-00900
Create a oracle db trigger using thin jdbc driver

currently I setting up a test environment for an application. I'm using jUnit and Spring in my test environment. Before …

Read More
java sql oracle triggers ora-00900
ORA:00900 Invalid sql statement

i created a procedure with 32 in argument,it sucessfully created.but when i am executing this in back end oracle …

Read More
sql oracle plsql ora-00900