将多个参数作为输入传递给游标 [英] Passing multiple parameters as input to cursor

问题描述

大家好..

我有一个Web服务，其中需要将多个guestlit作为输入传递给游标，然后发送给Oracle(SPMS).

这是我的代码.

Hi all..

I have a web service in which I need to pass multiple guestlit as input to a cursor and send to Oracle (SPMS).

Here is my code.

param = New OracleParameter([Enum].GetName(typeParam, CompCheckIn.EnumCompleteCheckIn.p_guest_list), OracleType.Cursor) 
param.Value = paramArrGuestList (-> here i am pasing multiple guestlist to cursor as input)
param.Direction = ParameterDirection.Input
paramArr(indx) = param
indx = indx + 1

我的问题是我没有收到来自SPMS的任何响应，响应什么都没有.

有人可以建议我在这种情况下我应该使用refcursor 代替游标吗?可以使用游标作为输入吗?

请帮助我解决这个问题.
在此先感谢..

My issue here is I am not getting any response from SPMS, Response is nothing.

Can any one suggest me that in this instance should I use refcursor in place of cursor?Can we use cursor as input?

Please help me in this issue.
Thanks in advance..

推荐答案

REF CURSOR是Oracle PL/SQL语言中的一种数据类型.它表示Oracle数据库中的游标或结果集. OracleRefCursor对象是REF CURSOR类型的对应ODP.NET类型.


将REF CURSOR传递给存储过程 [ ^ ]

The REF CURSOR is a datatype in the Oracle PL/SQL language. It represents a cursor or a result set in Oracle Database. The OracleRefCursor object is a corresponding ODP.NET type for the REF CURSOR type.


Passing a REF CURSOR to a Stored Procedure[^]

这篇关于将多个参数作为输入传递给游标的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！