从存储过程中，返回OUT参数& OUT光标&在.Net（Oracle）中解析结果 [英] From Stored Procedure, return OUT parameter & OUT cursor & parse result in .Net (Oracle)

问题描述

PROCEDURE myprocedure (myinput      IN Varchar2, 
                       myretcursor  OUT sys_refcursor,
                       p_count      OUT NUMBER,
                       p_message    OUT VARCHAR2) IS
BEGIN
   OPEN myretcursor FOR
      SELECT * FROM MYTABLE;
   p_count := 123;
   p_message := 'message';
END myprocedure

请使用c＃代码建议工作示例。

Please suggest working sample in c# code.

推荐答案

Oracle已将自定义.net提供程序提供给Oracle数据库。它被称为： Oracle Data Provider for .NET [ ^ ]。



以下是如何使用C＃实现这一目标： http://stackoverflow.com/questions/6491159/c-sharp-oracle-execute-stored-procedure-with-output-parameter [ ^ ]

Oracle has got custom .net provider to Oracle database. It is called: Oracle Data Provider for .NET[^].

Here is an idea how to achieve that using C#: http://stackoverflow.com/questions/6491159/c-sharp-oracle-execute-stored-procedure-with-output-parameter[^]

有一个使用sys_refcursor作为 oracle文档的输出参数的示例[ ^ ]



并且有一些例子在链接上使用你复制你的问题 [ ^ ]

There is an example of using sys_refcursor as an output parameter on the oracle documentation[^]

And there are examples of using both on the link that you copied your question from [^]

这篇关于从存储过程中，返回OUT参数& OUT光标&在.Net（Oracle）中解析结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！