Re: SELECT INTO when there is no data.

From: Martin Mølskov Hansen <mmh_at_kab-bolig.dk>
Date: Tue, 16 Mar 2004 08:56:38 +0100
Message-ID: <4056b33b$0$229$edfadb0f@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.
Received on Tue Mar 16 2004 - 01:56:38 CST