$sql = 'CALL match_animal(?, ?)';
$stmt = db2_prepare($conn, $sql);

$second_name = "Rickety Ride";
$weight =  0 ;

db2_bind_param($stmt,  1 , "second_name", DB2_PARAM_INOUT);
db2_bind_param($stmt,  2 , "weight", DB2_PARAM_OUT);

print "Values of bound parameters _before_ CALL:\n";
print "  1: {$second_name} 2: {$weight}\n";

db2_execute($stmt);

print "Values of bound parameters _after_ CALL:\n";
print "  1: {$second_name} 2: {$weight}\n";

$sql = 'call LSOM02.GET_OTPR_PAYER(?,?,?,?,?,?)';
$stmt = db2_prepare($conn, $sql);

$stamp1 = "2010-07-30-00.00.00";
$stamp2 = "2010-07-31-00.00.00";
$num1 =  100027162 ;
$num2 =  0 ;
$out1 =  0 ;
$out2 =  0 ;

db2_bind_param($stmt,  1 , "stamp1", DB2_PARAM_IN);
db2_bind_param($stmt,  2 , "stamp2", DB2_PARAM_IN);
db2_bind_param($stmt,  3 , "num1", DB2_PARAM_IN);
db2_bind_param($stmt,  4 , "num2", DB2_PARAM_IN);
db2_bind_param($stmt,  5 , "out1", DB2_PARAM_OUT);
db2_bind_param($stmt,  6 , "out2", DB2_PARAM_OUT);

print "Values of bound parameters _before_ CALL:\n";
print "  1: {$stamp1} 2: {$stamp2} 3: {$num1} 4: {$num2} 5:{$out1} 6:{$out2}\n";

if (db2_execute($stmt)) 
{
  print "Values of bound parameters _after_ CALL:\n";
  print "  1: {$stamp1} 2: {$stamp2} 3: {$num1} 4: {$num2} 5:{$out1} 6:{$out2}\n";
  print "Results:\n";
  while ($row = db2_fetch_array($stmt)) 
  {
    print "{$row[0]}, {$row[1]}, {$row[2]}\n";
  }
}