What should be the return type for a cursor variable?

5 like 0 dislike

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

asked 1 year ago by marck_don (191,010 points)

1 Answer

1 like 0 dislike

Best answer

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

answered 1 year ago by daneim (127,080 points)

Related questions

7 like 0 dislike

1 answer

What is use of a cursor variable? How it is defined?

asked 1 year ago by DBA-boss (120,990 points)

5 like 0 dislike

1 answer

How you open and close a cursor variable?

asked 1 year ago by daneim (127,080 points)

7 like 0 dislike

1 answer

Can cursor variables be stored in PL/SQL tables.If yes how?

asked 1 year ago by daneim (127,080 points)

7 like 0 dislike

1 answer

How you were passing cursor variables in PL/SQL 2.2?

asked 1 year ago by DBA-boss (120,990 points)

4 like 0 dislike

1 answer

What is the return type of Instr and Strcmp?

asked 1 year ago by daneim (127,080 points)