Hi
   I have a stored procedure which returns multiple values say..

CREATE OR REPLACE PACKAGE "ANS"."PKG_TEST1" as
   TYPE test_val IS TABLE OF paper.n_val%TYPE;
   procedure test_proc(v_alue out test_val);
 end;

CREATE OR REPLACE PACKAGE BODY "ANS"."PKG_TEST1" as
 procedure test_proc(v_alue out test_val) as
  begin
     select n_val bulk collect into v_alue from paper;
  end;
 end;

can any one help me to call the procedure and store the returned value in visual basic 6 so that i can manipulate the same .

 I use ADODB , & ORALCE PROVIDER FOR OLEDB for connection

what are the different ways I can call this stored procedure to return the above data ?

                 Please Help

see this

http://p2p.wrox.com/topic.asp?TOPIC_ID=5908

Ahmed Ali
Software Developer