Ronald, good point. I forgot to run commit via a sqlplus session. It works now.
Can DBI generate an error string instead of hanging for a situation like this? Thanks a lot for your help. Chang -----Original Message----- From: Ronald J Kimball [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2003 12:59 PM To: Chang, Mei Cc: '[EMAIL PROTECTED]' Subject: Re: $sth->execute and $dbh->do hung on Updating Oracle DB 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 ************************************************************** This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, please contact sender immediately by reply e-mail and destroy all copies. You are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. TIAA-CREF **************************************************************
