Oracle Stored Procedure

Hi there,

I would like to ask how the Oracle Stored Procedure be called by VB6 and for data report?

I have tried to get back a "Rowtype" but I have no idea how it can be collected by VB.

create or replace package test_sp10_pack is

   type rctl is ref cursor return CUSTOMER%rowtype;    procedure test_sp10_pack_sp ( rc1 in out rctl ); end ;

create or replace package body test_sp10_pack as

   procedure test_sp10_pack_sp ( rc1 in out rctl )    as begin
     open rc1 for select * from CUSTOMER ;    end;
end;

create or replace procedure test_sp10 ( rc1 in out test_sp10_pack.rctl) as
begin

   open rc1 for select * from CUSTOMER;
end;

Thks in advance for any helps
Nick Received on Sat Apr 29 2000 - 00:00:00 CDT