Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help!! Insert taking a very long time??

Re: Help!! Insert taking a very long time??

From: Gordon Cartwright <tabors_at_dircon.co.uk>
Date: 1996/12/14
Message-ID: <58tf1e$msh@newsgate.dircon.co.uk>#1/1

zlm101_at_psu.edu (Z. Martinez) writes:
> I'm having a bit of a problem in an INSERT command in SQL*PLUS.
> The SQL command goes something like this:
>
> INSERT INTO accounts (account_id)
> VALUES ('W11111');
>
> This INSERT hangs or takes a very long time, so I hit <CTRL>-C to stop
> it and get control back.
>
> What I cannot understand is that
>
> INSERT INTO accounts (account_id)
> VALUES ('W11112');
>
> works just fine!!!
>
> Does anybody have a clue on why this is happening?
> Can anybody suggest a way of debugging this problem?
>
> Thanks in advance for any information.
>
> Please forward reply to zlm101_at_psu.edu
>
>
>
>

I would guess the problem is in some trigger code. Do you have any triggers defined? Received on Sat Dec 14 1996 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US