my $params = {
                          p_PromoID             => $promo_id,
                          p_NumCodes          => $cnt,
                          o_NewCodes        => [ \$sth, 0, { ora_type => 116 } ],
                          o_Status          => [ \$error, 250 ],
                         };

      call_plsql( $dbh, 'wp.create_unique_codes', $params );