CMP or Stored Procedure?

[jun06]

Hi,

I have two options to implement my database-driven applicatioin. Should I use CMP or Stored Procedure? what are their adv and disadvantages?

Any one can help?

Thanks

Herman