Re: bind_param and bind_param_inout on insert

[Stacy Mader]

Tim Bunce wrote:
> 
> On Wed, Mar 27, 2002 at 02:14:25PM +1100, Stacy Mader wrote:
> >
> > When this statement is executed, Oracle complains:
> >
> > "Can't mix placeholder styles (:foo/?) at Oracle.pm line 293."
> >
> > Can the bind_param and bind_param_inout methods be
> > combined?
> 
> No. Like the message says.
> 
> Tim.

I solved my problem thusly:

$sth = $dbh->prepare(q{
  INSERT INTO TABLE
    VALUES (TABLE_SEQ.NEXTVAL,:1,:2)
      RETURNING fault_no INTO :3
        });

$x = 1;
foreach ($issue,$response) {
  $sth->bind_param("$x",$_);
  $x++;
}
$sth->bind_param_inout('3', \$rv, 5);
$sth->execute();


Regards,

        Stacy.