C# --> oracle proc, arrays vs cursors
523861May 16 2007 — edited Apr 16 2010Hi All,
I'm hoping for a bit of a C# help here. generally in the packages that I have at the moment that are called by C# web services, we are returning data in as a ref cursor.
what I'm wanting to do is either:
1) know if sending back a PL/SQL table (associative array) will be unable to be handled or can the C# handle the PL/SQL table as a dictionary type.
2) does anyone know of anyway I can open a ref cursor for the data in a PL/SQL table without first sticking it in a global temporary table etc.?
note: I'm not looking at changing existing procs without changing the c#, we're trying to write a new application.
Thanks in advance for the help!