Re: INSERT query freezes / hangs

From: Chris Leonard <chris_at_databaseguy.com>
Date: Mon, 1 Apr 2002 11:41:23 -0600
Message-ID: <aZ0q8.49$xj2.77087@news.uswest.net>

Hello Murtaza,

This is a longshot, but who knows? Googling (is that a verb yet?) through the following search

    "DBD::Oracle" +do +execute hang "1.12" seemed to show several problems that can cause hangs when using DBD or DBI. For example, check the following links:

    http://www.bitmechanic.com/mail-archives/dbi-users/Aug1997/0218.html
    http://www.bitmechanic.com/mail-archives/dbi-users/Aug1997/0227.html
    http://www.goss.com/perl/OraDemo/OraConnection.txt

Some of these errors only happen with local bequeath connections, so you might want to make sure you are using a TNS name. That is, make sure you use a connection string or database name, even if it is a local connection.

Good luck!
Chris

---

Chris Leonard
MCSE, MCDBA, MCT, OCP, CIW
The Database Guy at PPI
http://www.propoint.com
Brainbench MVP for Oracle Admin
http://www.brainbench.com

"Murtaza Nooruddin" <noorix_at_yahoo.com> wrote in message news:a89qjo$2vmh$1_at_news2.interpacket.net...
> I am running Oracle 9i on Red Hat 7.1 x86 Linux.
>
> When doing simple insert queries using DBD::Oracle (perl), the execute()
or
> do() functions both seem to hang indefinitely. However, queries are
working
> perfectly when used with sqlplus...
> Also, select query works smoothly.
>
> Please help!.
>
> Perl v.5.6.0
> DBD::Oracle ver. 1.12
>
>
> --Murtaza
>
>
>
>
Received on Mon Apr 01 2002 - 11:41:23 CST