Originally posted by Gulab Singh:
thank you sir for ur reply,
i have done as said by u, but now one the procedure is executed it will fetch the records and then close the cursur.
there is nothing coming in the recordset.
what i need to do is find some way to store the fetched records in a temporory table and return that table, so that i will get a result set on the another side.
can u help me in this.