excel查询没有oracle,来自Excel的Oracle和ADO查询不返回任何结果

我在使用Oracle OraOLEDB.Oracle Provider在Excel 2010 VBA代码中运行查询时遇到问题.

某些查询工作正常并返回结果,而其他查询没有返回结果…

我这样连接：

Set DBConnection = New ADODB.Connection

DBConnection.Provider = "OraOLEDB.Oracle"

DBConnection.CursorLocation = adUseClient

DBConnection.ConnectionString = "Data Source=" & TNSName & ";User Id=" & OraUserName & ";Password=" & OraPassWord & ";"

DBConnection.Open

然后我尝试查询：

command2.ActiveConnection = DBConnection

command2.CommandText = "SELECT COL1,COL2,COL3 FROM table(MySchema.MyPackage.MyFunction('Param1'))"

command2.CommandType = adCmdText

Set QueryRecordSet = New ADODB.Recordset

QueryRecordSet.LockType = adLockReadOnly

QueryRecordSet.CursorType = adOpenDynamic

QueryRecordSet.Open command2

command2.Execute

我一无所获……任何想法？

如果我运行一个简单的查询,如

select * From my_table

它工作得很好……似乎连接或其他更复杂的查询不编译？

此外,从视图中选择不起作用.

select * from my_view

什么都不返回