Cursor within cursor problem

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 332,602 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,247 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

•

FAQ | Community Rules | Welcome Guide

Please support our Oracle advertiser:

Thread Tools Display Modes

Views: 170 | Replies: 1 | Solved

•

Join Date: Apr 2008

Posts: 33

Reputation: veledrom is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

veledrom

Offline

Light Poster

Cursor within cursor problem

7 Days Ago

Hi guys,

Both cursor works if i don't use them in one Stored procedure. Both cursors return TRUE for(cursor_x%found). But, insert into process doen't work in cursor_1. Is there any structure problem?

Thanks

Help with Code Tags

(Toggle Plain Text)

CREATE OR REPLACE PROCEDURE ADD_RENTAL_SP 
IS

-- cursor1
CURSOR cursor_1 IS 
SELECT ......
rec1 VARCHAR(15);
-- cursor2
CURSOR cursor_2 IS 
SELECT ......
rec2 VARCHAR(15);

BEGIN

OPEN cursor_2;
LOOP
FETCH cursor_2 INTO rec2;
IF ( cursor_2%found ) THEN
  INSERT INTO .....
    ----
    OPEN cursor_1;
    LOOP
    FETCH cursor_1 INTO rec1;
      IF ( cursor_1%found ) THEN
        INSERT INTO ...
        EXIT WHEN cursor_1%found;
      END IF;
    END LOOP;
    CLOSE cursor_1;
    ----
  EXIT WHEN cursor_2%found;
END IF;
END LOOP;

COMMIT;
CLOSE cursor_2;
END;