the CLOB restrictions that i am facing are:
1. cannot specify a LOB as a primary key column.
2. cannot specify LOB columns in the ORDER BY clause of a query, or in the GROUP BY clause of a query or in an aggregate function.
3. cannot specify a LOB column in a SELECT... DISTINCT or SELECT... UNIQUE statement or in a join.
I am trying to create fields that can contain both short names and long text.
Edited by: 921776 on Mar 20, 2012 9:23 AM