如何存储Pl/Sql函数的返回值(表) [英] How To Store Pl/Sql Function return value(Table)

问题描述

我想将pl/sql的返回值存储在asp.net中，

下面的函数将返回表的cols名称

  ALTER  功能 dbo.sp_GetTableCols( VARCHAR (返回 表
 AS 
返回(选择 Column_Name 来自 INFORMATION_SCHEMA.COLUMNS 位置 Table_Schema = '  dbo' 和 Table_Name =  @ TableName )；
 GO  

如何将返回表值存储到asp.net中的变量中.

这是简单的示例，您会更好地理解
http://www.akadia.com/services/ora_return_result_set.html [ http://support.microsoft.com/kb/310070 [ http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson07.aspx [ ^ ]

您好，

您可以在一个包中创建一个过程，该过程将SYS_REFCURSOR和数据返回到.Net页面.

查看此链接以获取示例.

从OracledotNET调用Oraclestoredprocedures [ALTER FUNCTION dbo.sp_GetTableCols(@TableName VARCHAR(200)) RETURNS TABLE AS RETURN (SELECT Column_Name from INFORMATION_SCHEMA.COLUMNS WHERE Table_Schema = 'dbo' and Table_Name = @TableName); GO

how to store return table value in to a variable in asp.net

解决方案

You have to write a package for it.

here is the simple example, you will understand better
http://www.akadia.com/services/ora_return_result_set.html[^]

Thanks
--RA

These pages may help you :

http://support.microsoft.com/kb/310070[^]

http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson07.aspx[^]

Hi,

You can create a procedure in a package that returns the SYS_REFCURSOR to the .Net page with data.

Check this link for an example.

CallingOraclestoredproceduresfromMicrosoftdotNET[^]

这篇关于如何存储Pl/Sql函数的返回值(表)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！