Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help!! Insert taking a very long time??
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
![]() |
![]() |