Re: How To Trap No Rows Returned From Select Statement

"Chris \( Val \)" <chrisval_at_bigpond.com.au> wrote in message news:<2l1n0nF7m4jiU1_at_uni-berlin.de>...
> "Tony" <andrewst_at_onetel.net.uk> wrote in message
> news:c0e3f26e.0407060409.75c16a93_at_posting.google.com...
[]
> | SQL%NOTFOUND doesn't work because you have not performed any SQL at
> | that point in the program. You can do this:
>
> Thanks for the alternative - I realise where I went wrong now.
>
> | (I took the liberty of adding a useful ORDER BY clause to the query).
>
> I must admit that I didn't even think about it, presumably
> because I thought that the lines would be ordered by default
> anyway.
>
> Is this not the case ?
>
> Cheers.
> Chris Val

ORACLE is a RELATIONAL database, not a file system, so why would you expect the result set to be ordered?

Ed

(PS: I'm not so much harping on you as leaving useful information for beginners that might see this thread) Received on Wed Jul 07 2004 - 14:32:16 CDT