• Post Reply Bookmark Topic Watch Topic
  • New Topic

STORED PROCEDURE  RSS feed

 
RAJA BALASUBRAMANIAN
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How to process the loop and retrieve all the data's using cursor?
I have tried this code!

TYPE RECORD_VAR_NAME is table of FNR_DET%ROWTYPE;

FNR_REC RECORD_VAR_NAME;

BEGIN
OPEN FNR_DET;
LOOP
FETCH FNR_DET BULK COLLECT INTO FNR_REC;

EXIT WHEN FNR_REC.COUNT = 0;

END LOOP;
CLOSE FNR_DET;
END;
How to store the bulk result in a table?
Can any one help me out in this?
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!