Hi Don,
I can not commit myself for this since I am very busy right now. Anyway I would not like ETP to be left out of Oracle. So I fired up my oracle and crossed my fingers that my oracle still works. Its been while since I used my Oracle.
Here is the first fix on tcl/etp-procs-oracle.xql this is the correct query clause
<partialquery name="etp::get_content_items.gci_orderby">
<querytext>
sort_order
</querytext>
</partialquery>
I have also found a bug in moving the sort order. So I think the problems with ETP will be to deal with the tree_sortkey in Oracle. I will try to fix but no promises.
Guys and Gals please pitch in. I know Luke P is also very busy that is why ETP 2.0 is not moving that much. I know for sure I am guilty of not moving ETP 2.0.