Top "Ora-00911" questions

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

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 …

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/…

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: …

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

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. …

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; …

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 …

sql oracle executescalar ora-00911

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 …

php oracle json ora-00911