引用ado 2.0或更高版本 dim Cn as connection dim Cmd as command dim Rs as recordsetset Cn= new connection cn.connectionstring=连接语句Set Cmd = New Command Cmd.ActiveConnection = Cn Cmd.CommandType = adCmdStoredProc Cmd.CommandText = 存储过程名Set Rs = New Recordset Rs.CursorLocation = adUseClient Set Rs = Cmd.Execute 'Rs就是存储过程返回的记录集
oracle在存储过程不能直接返回结果集,要用REG CURSOR
那oracle不是要告到ms没内裤穿?
dim Cn as connection
dim Cmd as command
dim Rs as recordsetset Cn= new connection
cn.connectionstring=连接语句Set Cmd = New Command
Cmd.ActiveConnection = Cn
Cmd.CommandType = adCmdStoredProc
Cmd.CommandText = 存储过程名Set Rs = New Recordset
Rs.CursorLocation = adUseClient
Set Rs = Cmd.Execute 'Rs就是存储过程返回的记录集
需要进一步帮忙?