cursor를 open하는 프로시져를 만들고 호출해보세요. 

CREATE PROCEDURE sqlsamp ( IN dpt varchar(4) )
    SPECIFIC sqlsamp
    RESULT SETS 1
    LANGUAGE SQL
------------------------------------------------------------------------
-- SQL Stored Procedure sqlsamp
------------------------------------------------------------------------
P1: BEGIN
    -- Declare cursor
    DECLARE cursor1 CURSOR WITH RETURN FOR
        SELECT
              DEPARTMENT.DEPTNO,
              DEPARTMENT.DEPTNAME,
              EMPLOYEE.FIRSTNME,
              EMPLOYEE.MIDINIT,
              EMPLOYEE.LASTNAME
        FROM
           DEPARTMENT,
           EMPLOYEE
        WHERE
           (
              (
                EMPLOYEE.EMPNO = DEPARTMENT.MGRNO
              )
             AND
            ( (
                 DEPARTMENT.DEPTNO = dpt
              ) )
           );

    -- Cursor left open for client application
    OPEN cursor1;

END P1