Vasu,
Since this is the Oracle forum, I will assume you are using an Oracle database, and that your stored procedure is a PL/SQL stored procedure.
Use the "SQL%ROWCOUNT", for example:
See the
PL/SQL User's Guide and Reference for more details. The guide is available from:
http://tahiti.oracle.com Good Luck,
Avi.