How to use record count when executing SP against oracle?

[MrNorth]

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

[goatsucker]

Use a command object:

dim cmd as adodb.command
dim rst as adodb.recordset
dim cn as adodb.connection
 
set cn = new adodb.connection
cn.open strconnectionString
 
set cmd = new adodb.command
 
cmd.commandtext = "P_SD23_CERTIFICATE_SELECT"
cmd.commandtype = adCmdStoredProc
cmd.activeconnection = cn
 
set rst = cmd.execute

This code should fill the recordset rst with the contents of "P_SD23_CERTIFICATE_SELECT"