oracle table of number parameter = vb ?

[brenaaro]

More Oracle woes..

Ok so I have declared a type and a procedure header in a package like so:

type SeqNums is table of number;

 procedure GetSeqNums(l_user_id in CREDIT_CARD_LOG.USER_ID%TYPE, SeqGroup in OUT SeqNums);

and in my package body the procedure looks like this:

  procedure GetSeqNums(l_user_id in CREDIT_CARD_LOG.USER_ID%TYPE, SeqGroup in OUT SeqNums) IS
  begin
  
    declare
    cursor ccl_cursor is select seq_number from credit_card_log where user_id = l_user_id;
    ccl_req ccl_cursor%ROWTYPE;
    
    l_count NUMBER;

    begin
  
    l_count := 1;
      
    for ccl_req in ccl_cursor
    loop  
          SeqGroup.EXTEND;
          SeqGroup(l_count) := ccl_req.seq_number;
          l_count := l_count + 1;
    end loop;
  
  end;
  end GetSeqNums;

What I want to do is call this procedure from VB, passing it a userID, and return an array of all the SEQ_NUMBER s for that user's records. The field SEQ_NUMBER is of type NUMBER.

I can't figure out what type of parameter to create in VB though, I've tried adVariant, adArray Or adNumeric and various other combinations.

So my first question is what VB type corresponds to table of number, and second, should I be using 'table of number' or something else to return an array?

Thanks

[GarrottuN]

Hi,
You can create a type Varchar2 parameter who contain all the numbers returned by the query, separeted by ";", return it to VB and use .split to retrieve all the numbers and put to an array.

That's an easy way...