Which way is moer faster for this?

I have a procedure to return a set of records such as p_b, p_a .. Among then, one of the record is return by using another record. so My question is that in the BEGIN section of the Procedure, Do I just use another

   p_b(count):= v_b; <-- v_b is the select result    BEGIN

      SELECT a INTO v_a FROM table_B WHERE b = v_b; 
       p_a(count):= v_a;
   EXCEPTION
      WHEN OTHERS THEN
         p_a(count):= NULL;
   END;
     

• Where v_b is the retrun value of the main select process of the procedure or I need to put the SELECT a INTO v_a FROM table_B WHERE b = v_b; in a function call so that for p_a ( which is the return variable), I just use the p_b(count):= v_b; p_a(count):= functionCall_a( v_b);

   p_# is the return variable.

C Chang Received on Wed Jun 05 2002 - 22:21:39 CDT