Stored Procedure for advance reporting

[sam]

Hi,

Can anyone tell me where I can download examples for creating Stored 
Procedure in perl DBI?
It seems that I can't create advance reporting with basic operations 
(select, create) in perl dbi, so I m looking for whether Stored Proc in 
MySQL can solve my problem.

Thanks
Sam