Category Archives: Oracle

How to solve this error message “ORA-06502: PL/SQL: numeric or value error string”?

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

Posted in Oracle | Leave a comment

How to autoincrement a field in oracle?

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

Posted in Oracle | Leave a comment

Oracle Error 12154

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

Posted in Oracle | Leave a comment