Passing multiple parameters as input to cursor

See more:

VB

Oracle

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..