Oh.. Sorry about that. The module does state that it needs 5.8, but that is just because I made it on 5.8. I do not think it really depends on 5.8. I will try to find out if it works on 5.6 and if so, fix the version requirement.

Is there a way that the prepare statement can take any procedure name from the command line and execute it?

It is not difficult to just take a procedure name and have your program write the SQL to invoke it dynamically (this is, after all, how DBIx::ProcedureCall works). The tricky part is figuring out how many parameters and return values you need, and how they need to be bound. Especially OUT parameters (which you seem to use) are difficult.

Update: Version 0.08 of DBIx::ProcedureCall should now also work on Perl 5.6 and includes a command line tool that lets you do

perl -MDBIx::ProcedureCall::CLI -e procedure Par_Reports_Pos.sun_t_att
+m_temp_posm1d002 :code :msg
[download]