Results 1 to 2 of 2

Thread: cursor

  1. #1
    Join Date
    Nov 2008
    Posts
    26

    Unanswered: cursor

    Hi

    i have a query .here t_cursor is a refcursor declared in a package.

    PROCEDURE SP_FILLSERREQTYPE( IO_CURSOR IN OUT T_CURSOR)
    is
    V_CURSOR T_CURSOR;
    begin

    OPEN V_CURSOR FOR
    SELECT m_ps_docmode.DMID, m_ps_docmode.DOCMODENAME FROM m_ps_docmode;
    IO_CURSOR := V_CURSOR;


    I m opening this cursor and returning the result in a dataset .after tat shall i close the cursor or is there any need to close the cursor?????
    will this affect performance????????

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    always close cursors
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •