Re: How can I update DB using PERL?

"³ëÈñ°æ(Hui Kyoung)" wrote:

> *** 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!!!

I'm new to this myself and just guessing. But could it be that your perl-variables contains something that invalidates
the expression, for instance a comma:, or an unclosed quote:'. Or should there be a semicolon:; at the end of the line.

Cheers Received on Thu Nov 04 1999 - 02:30:12 CST