Category Archives: Oracle
Just declare id Number, if you declare a field with this datatype Number(1,1) which means you are only one digit is allowed. If you have inserted 10 row, at tenth row, you will have this error.
Here is the link that I used as reference, http://jen.fluxcapacitor.net/geek/autoincr.html CREATE TABLE “Database1”.”table1″ ( “Id” NUMBER NOT NULL ENABLE, “Field2” VARCHAR2(50 BYTE), “Field3” DATE, “Field4” VARCHAR2(2000 BYTE), “Field5” VARCHAR2(50 BYTE), “Field6” VARCHAR2(4000 BYTE), “Field7” VARCHAR2(50 BYTE), “Field8” VARCHAR2(50 BYTE) … Continue reading
http://ora-12154.ora-code.com/ ORA-12154: TNS:could not resolve the connect identifier specified Cause: A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of … Continue reading