查看此示例。
http://www.oracle.com/technology/pub...efcursors.html


我不确定DataTable是什么。

您可能也想查看EnterpriseLibrary.Data块。


它是一个抽象的方法与数据库交谈，有一个Oracle具体的

版本。


< je ********** @ gmail.com写信息

新闻：11 ********************* @ x40g2000prg.googlegro ups.com ...

See this example.
http://www.oracle.com/technology/pub...efcursors.html

I''m not sure about the DataTable thing.
You might want to look at the EnterpriseLibrary.Data block as well.

Its an abstract way to talk to databases, and there is an Oracle concrete
version.


<je**********@gmail.comwrote in message
news:11*********************@x40g2000prg.googlegro ups.com...

你好：

我正在使用Oracle .NET存储过程。我想知道

如何返回SELECT语句的结果。我已经尝试了返回OracleRefCursor和DataTable的
，但似乎没有什么工作。


我必须返回什么数据类型这个被接受为.NET存储

程序？


非常感谢，

Travis

Hello:

I am working with Oracle .NET Stored Procedures. I would like to know
how to return the results of a SELECT statement. I have tried
returning a OracleRefCursor and a DataTable, but nothing seems to
work.

What data type must I return for this to be accepted as .NET stored
procedure?

Thanks a lot,
Travis

* je ******* ***@gmail.com 写道，On 30-7-2007 5:18：

* je**********@gmail.com wrote, On 30-7-2007 5:18:

你好：


我正在使用Oracle .NET存储过程。我想知道

如何返回SELECT语句的结果。我已经尝试了返回OracleRefCursor和DataTable的
，但似乎没有什么工作。


我必须返回什么数据类型这个被接受为.NET存储

程序？


非常感谢，

Travis

Hello:

I am working with Oracle .NET Stored Procedures. I would like to know
how to return the results of a SELECT statement. I have tried
returning a OracleRefCursor and a DataTable, but nothing seems to
work.

What data type must I return for this to be accepted as .NET stored
procedure?

Thanks a lot,
Travis

请参阅Microsoft KB中的示例：

http://support.microsoft.com/default...b;EN-US;310101


Jesse

See this example from the Microsoft KB:

http://support.microsoft.com/default...b;EN-US;310101

Jesse

你仍然不理解我的问题。我不打算调用

存储过程，而不是典型的PL / SQL意义。好的，将.NET程序集上传到Oracle数据库是可能的。这样做，

数据库引擎可以在上下文中执行.NET程序集。在

a意义上，您正在执行.NET程序集，就像您在任何其他PL / SQL存储过程中执行一样。


这不是PL / SQL。我不是想要一个引用游标。我正在尝试

从.NET存储过程中获取select命令的结果。

如果您不知道我在说什么，请查看此链接关于 ：
http://www.oracle.com/technology/pub...liams_sps.html 。


如果您花时间查看链接，您将确切地知道我正在谈论的是什么。我已经显示的所有示例链接都是

，用于处理ADO .NET或编写PL / SQL。我只想从.NET存储过程中获得一个

结果集。并且，是的，它*是*，真的，

真的，一个.NET存储过程。


请，有人，

Travis

You are still not understanding my question. I am not trying to call a
stored procedure, not in the typical PL/SQL sense. Okay, it is
possible to upload a .NET assembly to an Oracle database. In doing so,
the database engine can execute the .NET assembly under a context. In
a sense, you are executing a .NET assembly just like you would any
other PL/SQL stored procedure.

This is not PL/SQL. I am not trying to get a ref cursor. I am trying
to get the results of a select command from a ".NET stored procedure".
Check out this link if you have no clue what I am talking about:
http://www.oracle.com/technology/pub...liams_sps.html.

If you take the time to look at the link, you will know exactly what I
am talking about. All the example links I have been shown have been
for working with ADO .NET or writing PL/SQL. I just want to get a
result set from a .NET stored procedure. And, yes, it *is*, really,
truly, a .NET stored procedure.

Please, someone,
Travis