Hi All,

How do I return resultset from Stored Procedure to the application?

Thanks,
t

Through a cursor.
1) declare it (WITH RETURN TO CALLER)
2) open it
3) end SP

Leaving it open will return the result set to the caller

HTH

Andy

Decalre number of resultset that the SQL procedure returns of Create Procedure statement using RESULT SET n, where n is the number of result sets.
Declare cursor CURSOR WITH RETURN FOR
Open cursor
Exit from Procedure without closing cursor

Cheers
Beepyata