Re: SELECT INTO when there is no data.

"Martin Mølskov Hansen" <mmh_at_kab-bolig.dk> wrote in message news:4056b33b$0$229$edfadb0f_at_dread12.news.tele.dk...
| Try to split up your script and select one record at the time.
| In the end you will find which record(s) returns null.
|
| Or if this helps any thy this:
|
| Begin
| <Your entire statement>
| exception
| when others then
| NumOfRecords := 0;
| End;
|
| Regards
| Martin M. Hansen
|
| "moshe" <Moshe_t_at_yahoo.com> skrev i en meddelelse
| news:616be6f6.0403152300.65ecca17_at_posting.google.com...
| > Hi,
| >
| > I'm using the SELECT INTO syntax in my SP.
| > Sometimes, the SELECT returns no records, and the SP raise exception
| > for that reason.
| >
| > My solution : Firsly use SELECT COUNT(*) INTO NumOfRecords and then
| > check
| > the NumOfRecords, If it's greater/equal to 1 continue to the next
| > SELECT INTO.
| >
| > I believe that there's another better solution for that situation. Any
| > suggestion will be welcome.
| >
| > With thanks,
| > Moshe.
|
|

read up on exception handling, and cursors, in the PL/SQL manual or a basic PL/SQL text

;-{ mcs Received on Tue Mar 16 2004 - 11:43:29 CET