in reply to Error while calling Oracle stored procedure

Are you sure that the following is valid Oracle SQL syntax?

drop_user_table(parameter1_in => :parameter1);

Especially the fat comma => strikes me as weird. But maybe Oracle has learned important things from Perl.