On Thu, Jun 19, 2003 at 10:46:56AM -0600, Chang, Mei wrote: > I wrote a simple test script to update Oracle database, but it hung on the > line of $dbh->do($sql2). > > Oracle server: NT, oracle version 8.0.3 > > my script running on W2000, with perl 5.6.1.633, DBD-ORACLE and DBI 1.34 > > The select statement "$sql1" works fine, but the script hung on the line of > $dbh->do($sql2) while trying to update oracle database. > > (Note: The $sql2 statement worked fine from sqlplus 8.1.7 on my PC. The > records were updated succesfully.)
If the sqlplus session is still open, did you remember to call commit? Ronald
