Re: SELECT INTO when there is no data.

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 - 08:56:38 CET