title: ORA-20000: Oracle Text error: DRG-10599: column is not indexed
body: <p>Hello I cant really make this sql workin because error column is not indexed (when i was using just like "=" it was all right) but I need contains for lazy typing purposes. I was searching the net, but the examples are always on so much different concept, than I have here. Can someone make example for this sql, how to make index please? the TextBox1.Text is inserted value of last name by user.</p>
  
  <pre><code>SELECT * FROM v_employees_intr 
  where CONTAINS(NLSSORT(LAST_CZ, 'NLS_SORT = hungarian_ai'), NLSSORT('%" + TextBox1.Text + "%', 'NLS_SORT = hungarian_ai'))&gt;0  
  ORDER BY " + RadioButtonList1.SelectedValue.ToString() + " ASC"
  </code></pre>
  
  <p>How to create a Text index? I tried to </p>
  
  <pre><code>CREATE INDEX myindex ON docs(text) INDEXTYPE IS CTXSYS.CONTEXT 
  </code></pre>
  
  <p>Because <a href="http://docs.oracle.com/cd/B28359_01/text.111/b28303/ind.htm#CIHJAJF%E2%80%8C%E2%80%8BJ." rel="nofollow noreferrer">Oracle web site</a> says it is basic for <code>contains()</code>. But this error message pop out <code>ORA-02158: invalid CREATE INDEX option</code>. So I tried to add the ; on end like <code>IS CTXSYS.CONTEXT;</code> and there then goes <code>ORA-00911: invalid character</code> error. Please can someone help me create index for my query?</p>