"ORA-00936:missing expression" when insert

[M. Jang]

Hello,

I wrote a simple insert program like

    $sth = $dbh->prepare( qq{
        INSERT INTO $table VALUES ($values[0],?,?,?,?,?,?,?,$values[8],
        $values[9], $values[10],?,?,?,?,?,?,?,?,?)
    } );
    $sth->execute($values[1],$values[2],$values[3],$values[4],$values[5],
        $values[6],$values[7],$values[11],$values[12],$values[13],
        $values[14],$values[15],$values[16],$values[17],$values[18],
        $values[19]);

and got ORA-00936:missing expression error message.

I saw each $values[n] string has correct value.

any suggestion, plz?


Mikyung/