ORA-00972: identifier is too long
936666Oct 26 2012 — edited Oct 29 2012I am having a query which will be inserting to table of 110 columns , where the values of 110 column length is about 1600 which i have spitted accordingly and i tried to insert the records into the table while inserting i am getting the below error
ORA-00972: identifier is too long
the 110 columns is the combinations of float ,number, var-char, char time ,date so i have spitted accordingly. my table name length is 13 character and i have used only single quotes for insertion
The insertion string length with comma separation is around 1710
Eg: insert into mytable values(1,2,'a',1,2,'b',time.............................)
Total length of my above string is about 1710
Thanks!