my $sql = "CBT.SP_LOG_CONSOLE(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
my $sth = $dbh->prepare( $sql );

my @params = ...;  # you need 10 values here

$sth->execute( @params );