Oracle StoredProc from VB 6.0

Giganews Newsgroups
Subject: Oracle StoredProc from VB 6.0
Posted by:  usamat…
Date: 10 Oct 2005

Hello Friends,
I am trying to find out how to Call Oracle Stored Proc from VB6.0 +
ado that takes in three strings as  IN parameters and outputs an array
of records or result set having file names and file paths. Any examples
would be appreciated.

mypackage.GET_Files(acctno, field2, field3, rec_array)
where IN parameters are all of type Varchar2(10),
and Out Parameter rec_array IS RECORD(file_path VARCHAR2(10), file_name

Thanks in advance.
Jack Anderson