close YYY 바로 다음에 deallocate cursor YYY 로 내부에 선언된 커서를 메모리에서 해제하셔야 합니다.

다음은 ASE 12.5.0.2에서 개발한 예제입니다.

create procedure sp_makeTABLE03 
as 
begin 
    set nocount on 
    delete from TABLE03 
 
    declare @sAcctCode      char(9), 
            @sChildAcctCode char(9), 
            @sCalcMethod    varchar(500), 
            @nSign          int 
 
    declare cursor_1 cursor for 
        select distinct sAcctCode 
        from TABLE04 
 
    open cursor_1 
 
    fetch cursor_1 into @sAcctCode 
 
    while ( @@sqlstatus = 0 ) 
    begin 
        select @sCalcMethod = "" 
 
        declare cursor_2 cursor for 
            select sChildAcctCode, nSign 
            from TABLE04 
            where sAcctCode = @sAcctCode 
            order by sChildAcctCode 
 
        open cursor_2 
 
        fetch cursor_2 into @sChildAcctCode, @nSign 
 
        while ( @@sqlstatus = 0 ) 
        begin 
            select @sCalcMethod = 
                ltrim(rtrim(@sCalcMethod)) + (case when @nSign = 1 then '+' else '-' end) + @sChildAcctCode 
 
            fetch cursor_2 into @sChildAcctCode, @nSign 
        end 
 
        insert into TABLE03 values (@sAcctCode, 0, @sCalcMethod) 
 
        close cursor_2 
        deallocate cursor cursor_2 
 
        fetch cursor_1 into @sAcctCode 
    end 
 
    close cursor_1 
    deallocate cursor cursor_1 
end

go