Shulou(Shulou.com)06/02 Report--

Today, I will talk to you about how to return cursors by calling stored procedures in Oracle.ManagedDataAccess. Many people may not know much about it. In order to make you understand better, the editor has summarized the following for you. I hope you can get something according to this article.

First, open PSSQL and create a package name in the database. The return type is ref cursor.

Then I write a simple test stored procedure, in which the pc_cursor output parameter is defined as the ref cursor in the package name we just established, and you can face the open pc_cursor for select * from statement directly in the process.

C # write call method

Oracle connection does not write much, you can check, mainly write how to call, we use the method is GetCursorFunction (OracleConnection con)

Finally, note that Dispose () is recorded, including the parameter of the defined cursor type

Next, let's take a look at the way we deal with data displayed by dataset.

Finally, let's look at our output.

After reading the above, do you have any further understanding of how to return cursors by calling stored procedures in Oracle.ManagedDataAccess? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.