How can I update DB using PERL?

From: Hui Kyoung <noddang_at_soback.kornet.net>
Date: Mon, 01 Nov 1999 18:26:15 +0900
Message-ID: <381D5CB7.C5A5D8AA@soback.kornet.net>

I'm not used to in English.. so will you do me a favor! ****

I had implemented inserting into a DB and selecting from a DB and I'm tring to update a DB (Oracle) using Perl at this time. but this isn't implemented .

I had done following as :
if table name is T1, field names are F1,F2,F3, and input variables
$V1,$V2,$V3

$dbh->do("update T1 set F1=$V1, F2=$V2, F3=$V3 where num=$v_num") || die
DBI->errstr;

that result is "ORA-00936: missing expression " but I don't know what I missed.

I'll wait for your answer!!! Received on Mon Nov 01 1999 - 03:26:15 CST