What should be the return type for a cursor variable.Can we use a scalar data type as return type?

The return type for a cursor must be a record type.It can be declared explicitly as a user-defined or %ROWTYPE can be used. eg TYPE t_studentsref IS REF CURSOR RETURN students%ROWTYPE

Interview Candidate
Aug 29th, 2004
3
2818

SQL

Answer

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

krishnaindia2007
Profile Answers by krishnaindia2007

May 16th, 2008

No we can not use a scalar data type as return type.
The return value of a strongly typed REF CURSOR must be a record which can be defined using the %ROWTYPE and %TYPE attributes or as a record structure.