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

Q

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

✍: Guest

A

The return type of a cursor variable can be %ROWTYPE or record_name%TYPE or a record type or a ref cursor type. A scalar data type like number or varchar can’t be used but a record type may evaluate to a scalar value.

2011-11-01, 2669👍, 0💬