You have to return the selected cursor as OUT parameter and again you hav

How to return multiple records from procedure?

Question Posted / swapna

Answer Posted / swapna

You have to return the selected cursor as OUT parameter and
again you have to fetch the data from that OUT cursor.

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

2139

What is the maximum size of sqlite database?

1148

Explian rowid, rownum?

1075

Can I call a procedure inside a function?

1072

What is nvarchar in sql?

973

What is sql*plus?

1117

What packages(if any) has oracle provided for use by developers?

5877

What are the sql commands?

1223

Where is pl sql used?

999

What does count (*) mean?

982

what is offset-fetch filter in tsql? : Transact sql

995

Is keyword pl sql?

1050

Is sqlexception checked or unchecked?

1006

How do you declare a constant?

1013

What are the rules to be applied to nulls whilst doing comparisons?

1363