title: Strange Oracle error: Identifier too long ORA-00972
body: <p>I have faced this problem when working with ORACLE 10g. I read the answers given to this question here (<b><a href="https://stackoverflow.com/q/2788031/431620"><a href="https://stackoverflow.com/q/2788031/431620">ora-00972 identifier is too long oracle 10g</a></a></b>) on stack overflow but they have not worked for me. Perhaps my situation is different.<br></p>
  
  <p>Now i had these table names:<code>WIMAX_TRAFFIC_STATS</code>  and <code>WIMAX_RADIO_STATS</code>. When i tried inserting data into them through an ODBC Connection with <b><a href="http://erlang.org" rel="nofollow noreferrer"><code>Erlang/OTP</code></a></b>, i got the error: <pre>
  {error,"[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00972: <br>identifier is toolong SQLSTATE IS: HY000"}
  </pre>
  So, i searched google and found answers saying that maybe my table names are too long. So i did this below and tried again:<pre>
  SQL&gt; ALTER TABLE WIMAX_RADIO_STATS RENAME TO WR;
  Table altered.
  SQL&gt; ALTER TABLE WIMAX_TRAFFIC_STATS RENAME TO WT;
  Table altered.
  </pre>
  I am still getting the same error. Other sources sya that it could be the data i am writing in some of my columns. My table definitions are here below: </p>
  
  <pre>
  
  SQL&gt; DESCRIBE WT;
   Name                                      Null?    Type
   ----------------------------------------- -------- -----------------
   SDATE                                              DATE
   ELEMENT_TYPE                                       VARCHAR2(50)
   MANAGED_ELEMENT                                    VARCHAR2(50)
   USER_LABEL                                         VARCHAR2(200)
   JOB_ID                                             VARCHAR2(50)
   MEAS_TYPE                                          VARCHAR2(50)
   MEAS_VALUE                                         VARCHAR2(50)
  </pre>
  
  <p>None of the data values i write there is longer than the column length definition. I really wonder. Am attempting to write strings that are less than 10 characters long in the table but yet still getting this error. <b>Some body help, please !</b></p>
  
  <p><b>EDIT</b><br><br>
  SAMPLE query request is as follows:</p>
  
  <pre>
  <b>INSERT INTO</b> WT(element_type,managed_element,user_label,job_id,meas_type,<br>meas_value) <b>VALUES</b>("BreezeMAX MBS",<br>"SubNetwork=ASN,MeContext=,ManagedElement=MBS.172.17.9.9",<br>"BMAX-Shoal2[MTN-Egate]",<br>"99297","rbMngmntPortPacketsDiscardedOnRx","0");
  
  </pre>
  
  <p>The SDATE field has a default set as <code>sysdate</code></p>