Re: Pro*C/Oracle8.0.5/DECOSF- problem with Dynamic SQL/CURSOR

I have encountered a similar problem in the past. Firstly, you need to check that your
program connects successfully to the Database. If you do not check this, and your connect fails, you will encounter the problem you are experiencing.

I suggest printing out values you are selecting from the loop. If they all appear to be NULL then the problem is as described above.

CoRey wrote:

> The problem has to do with selection of more than one row from
> the RESERVATION table. I'm trying to select entries like the
> following interactive command:
>
> SELECT * FROM RESERVATION WHERE MEALQUALITY<5
> AND FLIGHTDATE BETWEEN '15-APR-1999' AND '17-APR-1999';
>
> Reservation R(rrec, rind);
> R.print();
> }
> EXEC SQL CLOSE C;
> }
Received on Thu Apr 29 1999 - 04:29:49 CDT