wyrd Posted June 16, 2003 Posted June 16, 2003 Can .NET (C# specifically) handle a pointer to a cursor that's returned from either a UDF or Procedure (OUTPUT) from within SQL Server? If so where can I find some information on this? Quote Gamer extraordinaire. Programmer wannabe.
*Gurus* Derek Stone Posted June 16, 2003 *Gurus* Posted June 16, 2003 ADO.NET doesn't support cursors to any great extent, although the Oracle provider does include reference cursors, which will most likely be of little use to you. Quote Posting Guidelines
wyrd Posted June 16, 2003 Author Posted June 16, 2003 Well that's just sucky. I was at least hoping for an option to deal with cursors via pointers. Are there any sorts of hacks that I could look into for dealing with returned cursor pointers? Quote Gamer extraordinaire. Programmer wannabe.
*Gurus* Derek Stone Posted June 16, 2003 *Gurus* Posted June 16, 2003 Not that I am aware of, no. However if you provide us with some details I'm sure an alternative solution could be established. Quote Posting Guidelines
wyrd Posted June 17, 2003 Author Posted June 17, 2003 I wasn't talking about any problem I was having in particular, it was just more of a curious thing for future reference. Just about everything I can think of that would require a cursor can be done within a stored procedure or UDF, so I suppose in the end it doesn't really matter. But still, it would of been good info to know "just in case." Quote Gamer extraordinaire. Programmer wannabe.
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.