Re: PL/SQL Question

From: Lorenz Van den Broeke <lorenz.v_at_planetinternet.be>
Date: Sun, 7 Nov 1999 11:43:26 +0100
Message-ID: <803kge$52v$1@news.planetinternet.be>

When you use the

    FOR rec IN cursor syntax, your cursor is opened Implicitly and you don't need to close it.

You can open and close cursor explicitly by using the following syntax.

    OPEN cursor;
    LOOP

        FETCH cursor INTO record;
        EXIT WHEN cursor%NOTFOUND;
           ....

    END LOOP;
    CLOSE cursor;

Ciao Received on Sun Nov 07 1999 - 04:43:26 CST