How to return multiple records from procedure?
Answers were Sorted based on User's Feedback
Answer / hitendra yadav
We can return multiple records from procedure through
using reference cursor variable as out parameter of
procedure.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / 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 |
What is Primary Key?
What is synonyms?
What are the sql commands?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What are the types of subqueries?
How do I run a program in pl sql?
What is mutating error?
How well can multiple sessions access the same data simultaneously ?
What is oracle and pl sql?
What is sqlcontext?
How delete a row in sql?
What are the dml statements?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)