Closes a result set cursor.

Syntax

---

CLOSE <CursorName>

Usage

---

Use this statement to close a previously-opened result set cursor. If the cursor specified is not open, then this statement does nothing.

Examples

---

-- This procedure looks up the sales tax
-- rate for a given state and county

CREATE FUNCTION LookupSalesTaxRate(IN State CHAR(2), IN County VARCHAR)
RETURNS DECIMAL
BEGIN
   DECLARE TempCursor CURSOR FOR stmt;
   DECLARE Result DECIMAL DEFAULT 0;

   PREPARE stmt FROM 'SELECT * FROM SalesTaxes WHERE State = ? AND County = ?';

   OPEN TempCursor USING State, County;

   IF (ROWCOUNT(TempCursor) > 0) THEN
      FETCH FIRST FROM TempCursor ('TaxRate') INTO Result;
   END IF;

   CLOSE TempCursor;

   RETURN Result;
END

SQL 2003 Standard Deviations

---

This statement deviates from the SQL 2003 standard in the following ways: