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
