Posted by Erland Sommarskog on 02/13/07 22:40

(jweaver@xaware.com) writes:
> I'm having a problem getting back appropriate metadata for stored
> procedures from MS SQL Server 2000 and 2005.
>
> I've created a simple stored procedure that has an output param that
> is a cursor.
>
> When I ask for the metadata for that stored procedure using a JDBC
> driver I get back a datatype value for my parameter specifying an int
> not a result set.

I'm not really sure that I understand what you get back, but since there
is no result set from this procedure, you can't get back any information
about it.

Anyway, cursor is something you should avoid. In most caes, you should
look for a set-based solution. Cursors can be magnitudes slower.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]