On 05/03/2011 04:08, Alan J Davies wrote:

> You need this type of construct, (very, very simplified) if you want to
> return a number of records meeting your WHERE conditions, and you need
> to put your own requirements into the main body of the SP.

Thanks a lot Alan. I have been able to create both the procedures with
your help and both returns their expected values.

Kind regards
Bhavbhuti