Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    1

    Unanswered: How do I Pass array to be used in my select statement

    I want to be able to pass an array of integers into a Oracle stored procedure and then use that array to select the values to be manipulated by the procedure.

    ex Stored Procedure

    procedure test (testarray IN /*Array of Number*/)
    is
    -- Cursor to retrieve records
    CURSOR c_test IS
    select test_no, test_desc
    from test_table
    where test_id in /*testarray*/;

    BEGIN
    FOR v_test IN c_test LOOP
    /* work with data */
    END LOOP;
    END;

    Any help would be appreciated.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Exclamation

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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