Well I found the solution to my problem by updating to Oracle to 10g since any version
below 10g does not support the ORDER BY column that is not a part of the SELECT statement.
Also just a thought out loud, it seems that a lot of posts don't have any answer at
all. Folks please help out if you know the answer.
Thanks,
John
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3972554#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...