Re: Cursor Problem

In article <947866327.21704.0.nnrp-14.9e984b29_at_news.demon.co.uk>, jonathan_at_jlcomp.demon.co.uk says...
> The simplest change which may solve the problem is:
>
> >Cursor ResultCur (nMinTestResultHistoryID Number) Is
> > Select /*+ first_rows */ *
> > From ATT.Per_Test_Rslt_Hist
> > Where Num < nMinTestResultHistoryID
> > Order By Num Desc;
> >
>
> Otherwise try:
> > Select /*+ index (PTR PK_PER_TEST_RSLT_HIST) */ *
> > From ATT.Per_Test_Rslt_Hist PTR

I'll give it a try.

> It would help though if you told us which version
> of Oracle you were using.

7.3.3 Received on Fri Jan 14 2000 - 12:38:30 CST