Click here to Skip to main content
15,666,947 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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

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..
Updated 15-Aug-10 20:39pm

1 solution

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[^]
Share this answer
Espen Harlinn 15-Jan-11 7:33am    
5+ Good link

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900