MSSQL --> Oracle

Hi there,

How can I convert the following codes for MSSQL to Oracle?!
I wish to get back the same things by using Oracle.

MSSQL Server:
Create proc sp_test
as
select * from customer
return

VB Client:
......
........
strSQL = "{? = call sp_test ()}"
Set qdf = cnMSSQL.CreateQuery("sp_test", strSQL)
Set rst = qdf.OpenResultset(rdOpenStatic)
While rst.StillExecuting
DoEvents
Wend
With rst
if not (.bof and .eof) then
.movelast
.movefirst

while not .eof
msgbox rst("cust_id")
.........
..........
......
.movenext
wend
end if


Oracle cannot return recordset/resultset, that's why I have no idea how I can convert them for Oracle.

Thks in advance for any helps.

Regards,
Nick