Why wont my script finish?

From: Mark Martin (mark.martin_at_MAY.IE)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 14:19:52 +0000
To: dbi-users@perl.org

Hi,
I have a very simple script to delete records from an Oracle table :

#!/usr/bin/perl

use DBI;
use DBD::Oracle;

$dbh = DBI->connect( "dbi:Oracle:database", "user", "password") or die
"Can't connect to Oracle database: $DBI::errstr\n";

$dbh->do( "DELETE FROM TABLE WHERE YEAR=2003" );

exit;

the script never finishes and the records remain????

Thanks,
Mark

Relevant Pages

  • Re: OCIEnvNlsCreate error with DBD::Oracle 1.21 and Oracle 10g client in Cygwin
    ... If not: you could reinstall DBI and DBD::Oracle and make sure that your Oracle environment is set correctly. ... If you have multiple Oracle installations: set your $ENVusing the ORACLE_HOME with which you compiled your DBD::Oracle. ... If you have multiple perl installations (with DBI, DBD::Oracle) you may have to set the correct path to perl (first line of your script). ...
    (perl.dbi.users)
  • Re: DBD::CSV - UPDATE corrupts data!
    ... DBI 1.607, DBD::CSV 0.20, both runs deliver the same result from your first run. ... This are remnants from the shortening of the original program to generate a minimal test script. ... will try UPDATE Projects ...
    (perl.dbi.users)
  • Cant ctrl-c to exit with DBI, DBD::Oracle
    ... Once my script connects to my database, ... I just can't exit when I'm done. ... use DBI; ... I'm able to interrupt the script with ctrl-c as I'd expect. ...
    (perl.dbi.users)
  • Re: Why wont my script finish?
    ... > use DBI; ... > the script never finishes and the records remain???? ... If that is the actual SQL, TABLE is a reserved word so it would need to ...
    (perl.dbi.users)
  • MP2 - DBI Problem only under mod_perl: OCIEnvNlsCreate (check ORACLE_HOME and NLS settings)
    ... I am struggling with a DBI problem under MP2 ... A script that uses Oracle-DBI works ... I've tried setting every standard Oracle environment ...
    (perl.dbi.users)