I have the following Stored procedure in oracle:

create or replace procedure pogd.P_SD23_CERTIFICATE_SELECT(p_recordset out types.cursor_type) is
begin
open p_recordset for
SELECT CERTIFICATE,
CERTIFICATE_ID
FROM SD23_CERTIFICATE;
end P_SD23_CERTIFICATE_SELECT;


And in my vb code I declare an adodb.command object with NO parameters and use objCOmm.execute to run the stored procedure. My dilemma now is that I can't use the recordcount property cause I don't set any cursors or declare any recordset objects in the code. I return the value from the execute right away


public function getdata(byref conn as string) as ADODB.Recordset

bla bla

set getdata = objComm.Execute("P_SD23_CERTIFICATE_SELECT")
end function


And when I use the data I can't use recordcount....

Is there a way to solve this? I can't execute SP with a recordset object.... and I can't just declare a recordset and set it to

objRS = objComm.Execute("P_SD23_CERTIFICATE_SELECT")


How can I solve this? It is kinda urgent

kind regards
Henrik