Order by problem

[rguillen]

I am using the TOracleDataSet in my application with the next select "select partnumber, expired from b_partes order by partnumber"
and it was working fine but it start having problems. Now application is hanging when it open any select with two or more filds and the statement order by.

 

[Marco Kalter]

And without the order by it works correctly? Is it hanging on the client (100% CPU) or on the database server?

------------------
Marco Kalter
Allround Automations

 

[rguillen]

Originally posted by mkalter:
And without the order by it works correctly? Is it hanging on the client (100% CPU) or on the database server?

1.- Yes.

2.- The client request to server, but server dosn't responding.

 

[Marco Kalter]

What happens if you execute the same select statement in SQL*Plus?

------------------
Marco Kalter
Allround Automations