Stack Overflow
Stack Overflow

Questions tagged [ora-00911]

Oracle database error code ORA-00911: invalid character

Error:

ORA-00911: invalid character

Cause:

Identifiers may not start with any ASCII character other than letters and numbers. $#_ are also allowed after the first character. Identifiers enclosed by doublequotes may contain any character other than a doublequote. Alternative quotes (q'#. #') cannot use spaces, tabs, or carriage returns as delimiters.

Another very common cause is to have an extra semicolon added to the end of a query (e.g., select * from table;;)

Solution:

Correct the identifier name.

References:

50 questions
11
votes
1 answer

Why does running this query with EXECUTE IMMEDIATE cause it to fail?

I am writing a PL/SQL procedure that needs to to dynamically generate some queries, one of which involves creating a temporary table using results from a query taken as a parameter. CREATE OR REPLACE PROCEDURE sqlout(query IN…
GameFreak
  • 2,881
  • 7
  • 34
  • 38
8
votes
4 answers

ORA-00911: invalid character in C#, but not Oracle SQL Developer

I have a code line that's throwing an Oracle Exception - ORA-00911: invalid character when trying the following C# code: double tempDateTimeObj = Convert.ToDouble(someClass.GetTime(tempObjID, objStartTime, todayTime).Rows[0][0]); GetTime is a…
Kurt Wagner
  • 3,295
  • 13
  • 44
  • 71
6
votes
2 answers

Run multiple commands in one ExecuteScalar in Oracle

I have a batch of sql statements such as ... insert into.... ; insert into.... ; delete .........; etc When i try to execute them against oracle it gives me this error (ORA-00911 Invalid Character) now i can understand that this is because of the…
Kostas Konstantinidis
  • 13,347
  • 10
  • 48
  • 61
5
votes
1 answer

Oracle/PHP - ORA-00911 invalid character on UPDATE

I'm running a PHP script that updates a table from an Oracle DB instance. First, I receive an object with JSON: [{ "lot": "KLMHA17N9N00", "requestor": "B10078", "id": "FRESHLOT", "username": "B26696", "password": "B26696" }, { "lot":…
Arturo
  • 1,123
  • 3
  • 19
  • 33
5
votes
2 answers

ORACLE Batching DDL statements within a Execute Immediate

I'm trying to run multiple ddl statements within one Execute Immediate statement. i thought this would be pretty straight forward but it seems i'm mistaken. The idea is this: declare v_cnt number; begin select count(*) into v_cnt from all_tables…
Beta033
  • 1,975
  • 9
  • 35
  • 48
4
votes
1 answer

JDBC Call to a stored procedure returns null

I've got some problems with a stored procedure on an Oracle database. I just want to call a procedure (which has 50 IN parameters and 2 IN OUT parameters) and get these 2 OUT parameters. I'm trying to execute() the associated CallableStatement but…
Fabiz
  • 43
  • 2
  • 8
3
votes
1 answer

Oracle Query not executing properly in eclipse

I am executing a simple database query in Eclipse: statement.executeUpdate( "INSERT INTO DBUSER(USER_ID,USERNAME,CREATED_BY,CREATED_DATE) VALUES (3,'KUMAR','ERPDIRECT',to_date('29/08/2011', 'dd/mm/yyyy'));" ); But am getting: ORA-00911:…
nikks
  • 33
  • 2
3
votes
2 answers

How to get HL7 templates for Mirth Connect?

I'm new to this HL7 standard, but earlier I worked on NCPDP standard. Now I'm trying to explore Mirth Connect open source tool. When I'm trying to configure as per the documentation(User Guide) which is provided in…
learner
  • 625
  • 2
  • 11
  • 25
3
votes
2 answers

ORA-00911: invalid character Toad

I am using Toad 11.5 when I run multiple truncate statement, it gives an error ORA-00911: invalid character truncate table employees; truncate table employees_edit_history; truncate table sourcecontributioncalc; but when I run it one bye one , it…
Shahid Ghafoor
  • 2,991
  • 17
  • 68
  • 123
2
votes
1 answer

how to connecting to oracle database :((

I try to connect to oracle 11g but I have problem and receive the below error.the error show I must have problem in my sql syntax but I run it in oracle sql developer.the query is right Please help me to solve this problem Thanks. try { …
Amir
  • 1,919
  • 8
  • 53
  • 105
2
votes
2 answers

Spring Boot with Spring Data JPA gives invalid character issue for findOne(…) on Oracle database

My setup : Spring boot, using spring-data-jpa, Oracle 11g. I have same setup mentioned here on url, http://spring.io/guides/gs/accessing-data-jpa/ It works for hsqldb. I want to work with Oracle. So, I created the table in Oracle db. But, when I…
Rohit
  • 33
  • 1
  • 1
  • 7
2
votes
1 answer

Oracle 11g: ORA-00911: invalid character

When I write this, I am receiving the error "ORA-00911: invalid character" and I can't see this character. The code works fine up until the ALTER TABLE, that's where this character is. CREATE TABLE tbl_orders (Order_ID NUMBER NOT NULL, …
hickipedia
  • 21
  • 1
  • 2
2
votes
5 answers

Cannot executing a SQL query through ODP.NET - invalid character error

I'm trying to execute a SQL query through ODP.NET to create a table, but I always get an ORA-00911 'invalid character' error. The Errors object in the exception always has the text "ORA-00911: invalid character\n", even if there are no linebreaks in…
thecoop
  • 45,220
  • 19
  • 132
  • 189
2
votes
1 answer

ORA-00911: invalid character Error

DROP TABLE employee CASCADE CONSTRAINTS; CREATE TABLE employee ( fname varchar2(15) not null, minit varchar2(1), lname varchar2(15) not null, ssn char(9), bdate date, address varchar2(30), sex char, salary …
weia design
  • 1,250
  • 2
  • 14
  • 22
2
votes
3 answers

ORA-00911 Error when using double hyphen in comment

I have encountered an Problem on my Oracle 11 Express installation running on Windows Xp 32Bit. When I run a SQL-Script via Ant an Ora-00911 error is thrown every time when I use a double hyphen. When I run the exactly same code on my Oracle…
Eyeless
  • 33
  • 4
1
2 3 4