用于从Oracle中的表中选择所有行的存储过程 [英] stored procedure for selecting all rows from table in Oracle

问题描述

请注意:关于此问题，有几篇文章，但是由于一些关键词以及为什么使用，我没有得到这些文章.如何在 Oracle 中创建一个简单的存储过程，该存储过程从表中选择所有行.我完全想创建与以下用 SQL 编写的脚本相同的脚本.还有如何在Oracle中执行该过程并将其放置在 ASP.NET OracleCommand 对象中.

Please Note: There are several post regarding this, but I am not getting those due to some key words and why used? How to create a simple stored procedure in Oracle which select all rows from table. I exactly want to create same as below script written in SQL. Also How to execute the procedure in Oracle and place in ASP.NET OracleCommand object.

如何在Oracle中重新编写此SQL存储过程

How to re-write this SQL Stored Procedure in Oracle

CREATE PROCEDURE spGetData
AS
Begin
SELECT * from My_Table;
End

执行是sql

execute spGetData

推荐答案

声誉不高，因此无需评论即可添加答案.

Don't have much reputation so instead of comment adding answer.

要在Oracle中编写存储过程，并选择需要包括refcursor的所有行，因为游标将其用作指针并指向oracle结果集一个一并给出结果.

To Write Store Procedure in Oracle with select all rows you need to include refcursor,as cursor it will work as pointer and point to the oracle result sets one by one and give result.

Oracle的存储过程

Store Procedure For Oracle

CREATE OR REPLACE PROCEDURE spGetData(cursorParam OUT SYS_REFCURSOR)
 IS
  BEGIN
   OPEN cursorParam FOR
    SELECT * from My_Table;
END ;

要执行该命令，您需要

   var c refcursor;
    execute spGetData(:c)
   print c;

对ASP.NET的了解不多，但是可能需要添加游标参数

Don't have much knowledge about ASP.NET but may be yo need to add cursor parameter

  OracleCommand.Parameters.Add("cursorParam ", OracleType.Cursor).Direction =
ParameterDirection.Output;

谢谢.

这篇关于用于从Oracle中的表中选择所有行的存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！