So you would like to use a perl variable to get a sql variable reference? God Luck! :-)
if you whant to use stored procedures consult the manual for DBD::Your_Database and see if and how they are supported.
se this example from DBD::Oracle for some hints
(by the way i think "4" is not a valid identifier in sql :-))