Top "Ora-00001" questions

unique constraint (string.

What is the proper way to catch and handle ORA-00001 SQLException with JDBC?

I'm creating a simple form that stores entered data in an extremely simple Oracle database table via a Java Servlet …

Read More
oracle jdbc primary-key constraints ora-00001
Finding ghost constraint from Oracle DB

I had a constraint in a table CREATE TABLE "USERSAPPLICATIONS" ( "USERID" NUMBER NOT NULL , "APPLICATIONNAME" VARCHAR2 (30) NOT NULL , CONSTRAINT "PK_…

Read More
sql oracle unique-constraint ora-00001
PL/SQL (INSERT/UPDATE) unique constraint violated error in trigger due to sequencel.nextval

I want insert/update records to another table (MICL_SUPERVISORS) using Trigger (pl/sql oracle 10g). When trigger fired it …

Read More
oracle plsql triggers sequence ora-00001