CREATE PROC sp_proc1
          @param int OUTPUT
     AS
          SELECT @param = 1
          RETURN 0

##</code><code>##

my $param = 0;
$sql_obj->sql("EXEC sp_proc1 \@param = '$param' OUTPUT");