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 -> Problem with update

Problem with update

From: Marc Eggenberger <marc.eggenberger_at_itc.alstom.com>
Date: Wed, 7 May 2003 15:37:00 +0200
Message-ID: <MPG.19232a625accf98698968f@H02374>


Hi there ...

I have a few (couple hundrets) lines like this in a textfile:

update ams.hardware set kostenstl = '11016' where kostenstl = '11006';

and as last line I have a

commit;

when I connect to the Oracle 8i Server and do the following in sqlplus:

@{path_to_file}\updt.sql

it hangs ... if I do a
set echo on
I see, that it always hangs on the same update statement.

Am I missing something here? Some kind of buffer which is not big enough?

-- 
mfg
Marc Eggenberger
Received on Wed May 07 2003 - 08:37:00 CDT

Original text of this message

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