Top "Ora-00911" questions

Oracle database error code ORA-00911: invalid character

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), …

Read More
oracle11g ora-00911
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 …

Read More
sql oracle plsql dynamic-sql ora-00911
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/…

Read More
oracle hibernate spring-boot spring-data-jpa ora-00911
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: …

Read More
c# sql oracle-sqldeveloper ora-00911
PLSQL: BEFORE INSERT TRIGGER (check value in column from other table before allowing insert)

I've made a simple DVD store database. The DVD table has a column "status" which can be either 'FOR_RENT',…

Read More
oracle plsql triggers ora-00911
SQL Error: ORA-00911: Invalid Character

I'm an new to Oracle and I'm trying to create a table but I keep getting an invalid character warning. …

Read More
sql oracle ora-00911
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; …

Read More
oracle toad ora-00911
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 …

Read More
sql oracle executescalar ora-00911