Oracle ordering by a Text field fails

[Former user]

When using Oracle, ordering by a text field fails: DatabaseError: (DatabaseError) ORA-00932: inconsistent datatypes: expected - got CLOB

The solution would be to order by a casted version of a string: select my_clob from my_table order by cast(my_clob as varchar2(4000))

[Mike Bayer]

SQLA isn't going to make a decision like that for you, sorry.