List:MySQL and Java« Previous MessageNext Message »
From:Igor Dayen Date:April 25 2004 8:57pm
Subject:What is SQLSTATE for indicating empty result set?
View as plain text  
In the stored procedure fragment below there is a need to make some decision if table is
empty.

DECLARE CONTINUE HANDLER FOR SQLSTATE xxxxxx SET EMPTY_SET = 1;

 SELECT * FROM SOME_TABLE;

  IF EMPTY_SET=1 THEN
  ............

What is correct SQLSTATE for indicating this? Is there any SQLCODE reserved for this?

Thanks very much.
Thread
What is SQLSTATE for indicating empty result set?Igor Dayen25 Apr
  • Re: What is SQLSTATE for indicating empty result set?Paul DuBois25 Apr
  • Re: What is SQLSTATE for indicating empty result set?Igor Dayen25 Apr