Oracle Scenarios Question: Download Oracle Scenarios PDF

Can we create procedures to fetch more than one record?

We can create a procedure to return REF cursor or VARRAY or PL/SQL Table type out parameters which can return more than one value.

Previous Question	Next Question
Explain What is spooling?	Schema A has some objects and created one procedure and granted to Schema B. Schema B has the same objects like schema A. Schema B executed the procedure like inserting some records. In this case where the data will be stored whether in Schema A or Schema B?