Stack Overflow
Stack Overflow

Questions tagged [ora-00900]

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

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

29 questions
74
votes
7 answers

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 problems executing stored procedures. Procedure: create or replace procedure temp_proc is begin DBMS_OUTPUT.PUT_LINE('Test'); end it is created…
Rahbee Alvee
  • 1,924
  • 7
  • 26
  • 42
11
votes
2 answers

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 table is here: Table name: Ziaci Columns: ZiakId - primary key, number Surname, varchar2 FirstName, varchar2 TriedaId - forgein key,…
user572844
4
votes
3 answers

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 a test execution I want to set up a database test environment state. I already has written the SQL scripts (schema and data) and…
eglobetrotter
  • 718
  • 4
  • 10
  • 25
4
votes
6 answers

Switching users on a JDBC Connection

I am writing a Java JDBC database application that connects to an Oracle 11g database and am using a c3p0 connection pool. For the purposes of an example, I have 3 database users DEFAULT, TOM, and BILL. c3p0 opens all of the pooled Connections with…
jtbradle
  • 2,458
  • 6
  • 25
  • 26
3
votes
5 answers

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 exists, do an update otherwise create a record on the table. I'm trying to but i'm getting PLS-00103 error. These are the errors that I'm getting when i…
Jack
  • 9,843
  • 23
  • 78
  • 111
2
votes
2 answers

Using SQL stored function gives invalid SQL statement

I'm trying to use stored function from Oracle Express database in c# application. OdbcCommand com = new OdbcCommand("SILNIA",sqlConn); com.CommandType = CommandType.StoredProcedure; OdbcParameter sqlParam = new OdbcParameter("@ReturnValue",…
mmatloka
  • 1,986
  • 1
  • 20
  • 46
2
votes
1 answer

Run Sql*Plus commands on Application Express

I am new to PL/SQL, I'm trying to execute the commands that I learned at the course. VARIABLE area NUMBER DECLARE radius NUMBER(2) := &s_radius; pi CONSTANT NUMBER := 3.14; BEGIN :area := pi * radius * radius; END; I understand that I can…
pesantos
  • 23
  • 4
2
votes
3 answers

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 tell me what could be the reason?
Sandeep Kumar
  • 13,799
  • 21
  • 74
  • 110
2
votes
1 answer

BadSqlGrammarException through Spring-JDBC but not in SQLDeveloper

using the following query in SQLDeveloper to test merge everything goes fine: merge into proj.person_registry pr using ( select null as id, '69696696553' as code, 'TESTYMC' as name, 'WHATEVER' as firstname, 'M' as cl_gender, 'E' as cl_status,…
ollo
  • 926
  • 1
  • 14
  • 33
1
vote
2 answers

Good beginner resources to get started on Oracle Stored Procedure

I am looking for good resources on Oracle Stored Procedure geared towards beginners. I tried the Dev Shed Article and one from Oracle Documentation site but they did not meet my needs. The one form Oracle Documentation site had the overhead of Java…
tundal45
  • 193
  • 3
  • 14
  • 33
1
vote
1 answer

PLSQL procedure execution error invalid statement

I'm following a tutorial on PL/SQL http://www.plsqltutorial.com/plsql-procedure/. I have created procedure with the following code on apex: CREATE OR REPLACE PROCEDURE adjust_salary( in_employee_id IN EMPLOYEES.EMPLOYEE_ID%TYPE, in_percent…
aretai
  • 1,619
  • 6
  • 19
  • 30
1
vote
1 answer

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. I'm trying to run the following in PL/SQL developer. It gives an error saying: ORA-00900: Invalid SQL Statement VARIABLE mycur …
user2059532
  • 69
  • 1
  • 2
  • 7
1
vote
4 answers

WHERE conditions in subquery while using ANSI joins

Why doesn't it work? SELECT a.* FROM dual a JOIN (SELECT * FROM dual WHERE 1=1) b ON (1=1); I get "ORA-00900: invalid SQL statement". Is there a way to use WHERE clause inside the subquery? Edit: Version 9.2 SELECT * FROM…
jva
  • 2,797
  • 1
  • 26
  • 41
0
votes
2 answers

how to use these sql scripts in oracle?

I have a sql-script like: @tables\run.sql; @sequences\run.sql; @views\run.sql; @functions\run.sql; @procedures\run.sql; And I have two questions: Do I need to imply all the related script-files into the db? I execute the SQL script above in…
kaiwii ho
  • 1,367
  • 7
  • 21
  • 40
0
votes
2 answers

Unable to execute "DESCRIBE ARADMIN.EPM_TechnicianInformation" in python jupyter notebook with cxOracle

When I execute query "DESCRIBE ARADMIN.EPM_TechnicianInformation" like below: connection = cx_Oracle.connect(user=username, password=userpwd, dsn=dsn, encoding="UTF-8") cursor = connection.cursor() results = cursor.execute(" DESCRIBE…
Bharti
  • 15
  • 4
1
2