ODP.NET

Hi all,

I've spent quite some time trying to get this to work, but is appears that none of the code samples I have tried work with this version of ODP.Net : 2.102.2.20.

It's the most basic thing : return a weak typed resultset from an oracle function using weak typed SYS_REFCURSOR. I got this to work with a procedure, but no way this works with a function.

I'm using the code approach from this source : http://www.oracle.com/technology/pub/articles/mastering_dotnet_oracle/williams_refcursors.html


CREATE OR REPLACE FUNCTION
fn_getItemsByDispNumber(p_Number in varchar2)
return sys_refcursor
IS
resultset sys_refcursor;

begin

open resultset for
....select statement
return resultset;
end;

Exception is : ORA-06550: line 1
PLS-00306: wrong number or types of arguments in call to '(fn_getItemsByDispNumber)'

Using strong types is not an option I have too many columns adn result sets that it makes no sense.

I tried to obtain the sys_refcursor as return value and as output parameters and it's the same results. I also tried adding the return value parameter to the command object first, but with no luck (same error).


Is there some magical trick thet must be done for this simple thing to work ?


Thanks