On Wed, Sep 26, 2001 at 02:47:33PM -0700, Dave Storrs wrote:
>
> The following, if executed from within a Perl script, will hang
> indefinitely while trying to do the 'execute()' statement.
>
> my $sth = DBH()->prepare( "UPDATE ldb_ad_t SET most_recent_print_date =
> '30-SEP-01' WHERE lid = 2" );
> $sth->execute();
>
> DBH()->commit();
> DBH()->disconnect();
>
>
> Does anyone have any idea where to start looking for how to solve this?
> I can take the text of this UPDATE, issue it through sqlplus, and it works
> fine.
Make sure that you COMMIT in sqlplus, otherwise your sqlplus session will
have a lock on the table and/or rows and your DBI session will wait for it
to be released.
Ronald
