Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I update DB using PERL?

Re: How can I update DB using PERL?

From: John D Groenveld <groenvel_at_cse.psu.edu>
Date: 1 Nov 1999 15:55:55 -0500
Message-ID: <7vkuor$8hs$1@grolsch.cse.psu.edu>


In article <381D5CB7.C5A5D8AA_at_soback.kornet.net>, =?EUC-KR?B?s+vI8bDm?=(Hui Kyoung) <noddang_at_soback.kornet.net> wrote:
>$dbh->do("update T1 set F1=$V1, F2=$V2, F3=$V3 where num=$v_num") || die
>DBI->errstr;

$dbh->{RaiseError} = 1;
my $sth = $dbh->prepare( qq{

		UPDATE t1
		SET f1=?, f2=?, f3=?
		WHERE NUM=?
		});

$sth->execute($V1, $V2, $V3, $v_num);

What does this yield?
John
groenveld_at_acm.org Received on Mon Nov 01 1999 - 14:55:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US