If part of your question is 'how do I use a stored procedure in Perl?' then see How can I invoke stored procedures with DBI? from the DBI::FAQ.

Hope this helps

Martin