Solved...I found the order by clause had var+var...change to var,var...works
Sorry for the bother.

>I ask this question in the oracle forum but did not get a response so I will try here.
>I can create a oracle connection thru the command window and get a cursor of 3400 records. In code the result cursor never displays (stays in memory) or gets a workspace, it use to but I do not know what changed. My problem is that I copy that result as a table which drives over processes. Does anyone know why the _tally shows 3 or 4 records when it should show 3400? batchmode is false.