Thanks a lot ur your quick reply.
Since im new to PL/SQL im not aware of storedproc.
If you could provide me with somelinks or materials it will be very useful for me..