On Thu, Oct 15, 2009 at 4:14 PM, danclemson <danclemson@gmail.com> wrote:
>
> Thanks for the information.
>
> I did try the approach, but it failed due to any other issue with npgsql.
>
> The stored procedure returns a setof refcursor.
> If I use "select * from test('e1':testEnum)", the command.ExecuteReader does
> not return the datareader properly. The code errored out when I use the
> datareader to get the data in the refcursor.
>
if you can't figure out any other solution (there probably is one),
wrap your procedure in sql function that takes text and do the casting
there.
merlin