Results 1 to 2 of 2

Thread: Ref Cursors

  1. #1
    Join Date
    Feb 2006
    Posts
    46

    Unanswered: Ref Cursors

    What does the keyword Ref mean in the usage of a REF Cursor?

    Here is an example.

    Thanks

    --------------------------------

    Create or Replace Paclage Test Package
    As Type Test_Type IS Ref CURSOR RETURN TEST.TABLE%ROWTYPE;
    END TEST Package ;
    /

    Create or Replace Procedure Test Procedure
    ( Test Cursor IN OUT TEST_Package.Test_Type,
    Test_Parameter in TEst_Table.ID%Type)
    As
    etc
    etc

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    It is short for "reference", i.e. the variable is a reference (pointer) to a cursor.

Posting Permissions

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