Explain What Should Be The Return Type For A Cursor Variable. Can We Use A Scalar Data Type As Return Type

Explain What Should Be The Return Type For A Cursor Variable. Can We Use A Scalar Data Type As Return Type


  • 19 Dec, 2011

    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 CURSORRETURN students%ROWTYPE

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.