Index-by tables as stored procedure parameters?

From: David Fetter <shackle_at_fetter.org>
Date: 26 Sep 2000 21:43:56 GMT
Message-ID: <8qr5as$i8e$1@bob.news.rcn.net>

Kind people,

I'm writing some code for a general survey engine, and have the following stub:

    TYPE question_id_array
    IS
    TABLE OF NUMBER;     TYPE answer_array
    IS
    TABLE OF VARCHAR2(4000);     PROCEDURE StoreSurveyAnswer(

      survey_name_in       IN survey.survey_name%TYPE


    , user_uuid_in         IN resources.uuid%TYPE

    , question_id_array_in IN question_id_array

    , answer_array_in      IN answer_id_array

    );

How do I iterate over all the questions and get the corresponding answers? Or should the answer_array be indexed by the question_id numbers? Either way, how do I go through all of 'em?

Huge TIA for any tips, pointers or FM's to RT.

Cheers,
D

-- 
          David Fetter            888 O'Farrell Street Apt E1205
       david_at_fetter.org           San Francisco, CA 94109-9046
http://fetter.org/~shackle phone: +1 415 567 2690 fax: +1 415 567 2340

I planted some bird seed. A bird came up. Now I don't know what to
feed it.
                                       Steven Wright

Received on Tue Sep 26 2000 - 16:43:56 CDT