Answer Posted / vivekananda
It is used to return a recordset from a stored procedure.
There are two types of REF-CURSORS.
One is STRONG REF-CUSROR.
Another is WEAK REF-CUURSOR.
For the STRONG REF-CUSROR, the returning columns with
datatype and length need to be known at compile time.
For the WEAK REF-CUURSOR, no need to be known at compile
time.
Eg:
type STRONG_REF_CURSOR is REF CURSOR return EMP%ROWTYPE;
type WEAK_REF_CURSOR is REF CURSOR;
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can we import the data into a database using sql * loader?
What is oracle soa suite?
What do you understand by soa?
tell me the scenarios of the independent in reports
how can develope the po variance and po summary report? with tables mandatory columns and query please?
what are the prerequisites for costing transactions?
List the types of flexfield?
How do you register report in oracle apps?
Are you familiar with internet architecture of oracle apps 11i?
What are the Standard Reports and Forms in HRMS?
What do you understand by a set of books?
WHAT IS CUSTOM VIEW AND CUSTOM COMPONENT?
What does appl_top directory contain?
Explain what are the tables of auto invoice?
What is a flexfield? List out its types.